Menu
▾
▴
sql-ledger-users
|
From: Roy P <or...@sh...> - 2007-02-05 14:42:21
|
Morning all ! I want to install version 2.7 alongside version 2.6. Configuring the 2 installations in different directories with the required apache configuration is easy. But..... When I try create a test dataset in 2.7, it tells me that the id sequence exists. I guess that the id sequence is shared between datasets ? It there an easy way to have the id sequence be unique to each dataset ? Or is there something weird with my database configuration ? Cheers, Roy P |
|
From: Dieter S. <dsi...@sq...> - 2007-02-05 15:08:34
|
The id's are not shared. -- Dieter Simader http://www.sql-ledger.com Tel: (780) 472-8161 DWS Systems Inc. Accounting Software Fax: (780) 478-5281 ============== On a clear disk you can seek forever ================ On Mon, 5 Feb 2007, Roy P wrote: > Morning all ! > > I want to install version 2.7 alongside version 2.6. > Configuring the 2 installations in different directories with the required > apache configuration is easy. But..... > > When I try create a test dataset in 2.7, it tells me that the id sequence > exists. I guess that the id sequence is shared between datasets ? > It there an easy way to have the id sequence be unique to each dataset ? > Or is there something weird with my database configuration ? > > Cheers, > Roy P > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier. > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: Ashley J G. <agi...@pu...> - 2007-02-05 15:57:41
|
On Tuesday 06 February 2007 00:42, Roy P wrote: > When I try create a test dataset in 2.7, it tells me that the id sequence > exists. I guess that the id sequence is shared between datasets ? > It there an easy way to have the id sequence be unique to each dataset ? > Or is there something weird with my database configuration ? Are you using a separate databases for each? That's the setup that works fine for me with two systems. -- Regards, Ashley J Gittins web: http://www.purple.dropbear.id.au jabber: agi...@pu... |
|
From: Roy P <or...@sh...> - 2007-02-05 16:10:42
|
On Monday 05 February 2007 09:56, Ashley J Gittins wrote: > On Tuesday 06 February 2007 00:42, Roy P wrote: > > When I try create a test dataset in 2.7, it tells me that the id sequence > > exists. I guess that the id sequence is shared between datasets ? > > It there an easy way to have the id sequence be unique to each dataset ? > > Or is there something weird with my database configuration ? > > Are you using a separate databases for each? That's the setup that works > fine for me with two systems. Thanks Dieter and Ashley.. Hmmm.. ok then it's my config.... I'm using separate datasets and SL login, but the same postgresql user. Are you using a different postgresql user for each one ? I've done this before in the past (using the same postgresql user) and never had an error before.. I must have screwed up somewhere. Cheers, Roy P |
|
From: Tony F. <to...@sy...> - 2007-02-05 16:33:12
|
On Mon, 2007-02-05 at 10:10 -0600, Roy P wrote: > I'm using separate datasets and SL login, but the same postgresql > user. > Are you using a different postgresql user for each one ? > > I've done this before in the past (using the same postgresql user) and > never > had an error before.. I must have screwed up somewhere. Sounds to me like you got an id sequence created in your template1 database some how. -- Tony Fraser to...@sy... Sybaspace Internet Solutions System Administrator phone: (250) 246-5368 fax: (250) 246-5398 |
|
From: Roy P <or...@sh...> - 2007-02-05 16:42:10
|
On Monday 05 February 2007 10:35, Tony Fraser wrote: > On Mon, 2007-02-05 at 10:10 -0600, Roy P wrote: > > I'm using separate datasets and SL login, but the same postgresql > > user. > > Are you using a different postgresql user for each one ? > > > > I've done this before in the past (using the same postgresql user) and > > never > > had an error before.. I must have screwed up somewhere. > > Sounds to me like you got an id sequence created in your template1 > database some how. Exactly... Thanks Tony. I just figured it out when your email arrived. Cheers ! |
|
From: Roy P <or...@sh...> - 2007-02-05 16:42:23
|
On Monday 05 February 2007 10:10, Roy P wrote: > On Monday 05 February 2007 09:56, Ashley J Gittins wrote: > > On Tuesday 06 February 2007 00:42, Roy P wrote: > > > When I try create a test dataset in 2.7, it tells me that the id > > > sequence exists. I guess that the id sequence is shared between > > > datasets ? It there an easy way to have the id sequence be unique to > > > each dataset ? Or is there something weird with my database > > > configuration ? > > > > Are you using a separate databases for each? That's the setup that works > > fine for me with two systems. > > Thanks Dieter and Ashley.. > > Hmmm.. ok then it's my config.... > > I'm using separate datasets and SL login, but the same postgresql user. > Are you using a different postgresql user for each one ? > > I've done this before in the past (using the same postgresql user) and > never had an error before.. I must have screwed up somewhere. Looks like i found the problem.... You can tell it's Monday... i'm not fully awake yet... For some reason, the template1 database had a copy of the SQL-Ledger sequences in it. (This must have occured a long time ago on my test box) For those who don't know why this is a problem.... When you create a new database.. the template1 database is automatically used as a... well.... template. Therefore, in this case template1 already contained the sequences and when i tried to create a new dataset it failed because they already existed. Cheers and thanks all. Roy |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X