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 |