Re: Duplicate primary keys in Postgresql

2015-10-13 Thread Mike Kienenberger
t;>>> Hi Hugi, >>>> >>>> What are you using for PK generation? PostgreSQL's sequence generator >>>> should prevent duplicates. Make sure the number of keys it is allocating >>>> matches what Cayenne is using, though, otherwise

Re: Duplicate primary keys in Postgresql

2015-10-13 Thread Hugi Thordarson
tion? PostgreSQL's sequence generator >>> should prevent duplicates. Make sure the number of keys it is allocating >>> matches what Cayenne is using, though, otherwise you'll run into issues. >>> >>> mrg >>> >>> >>> On Tue,

Re: Duplicate primary keys in Postgresql

2015-10-13 Thread Mike Kienenberger
gt;> matches what Cayenne is using, though, otherwise you'll run into issues. >> >> mrg >> >> >> On Tue, Oct 13, 2015 at 5:38 AM, Hugi Thordarson wrote: >> >>> Hi again all! >>> >>> I’m running into a problem where I’m getting dup

Re: Duplicate primary keys in Postgresql

2015-10-13 Thread Hugi Thordarson
AM, Hugi Thordarson wrote: > >> Hi again all! >> >> I’m running into a problem where I’m getting duplicate primary keys in >> Postgresql, i.e. records are getting the same primary key (when multiple >> threads are writing to the same table). Any idea how I can prevent thi

Re: Duplicate primary keys in Postgresql

2015-10-13 Thread Michael Gentry
ote: > Hi again all! > > I’m running into a problem where I’m getting duplicate primary keys in > Postgresql, i.e. records are getting the same primary key (when multiple > threads are writing to the same table). Any idea how I can prevent this? Do > I have to perform any manual

Duplicate primary keys in Postgresql

2015-10-13 Thread Hugi Thordarson
Hi again all! I’m running into a problem where I’m getting duplicate primary keys in Postgresql, i.e. records are getting the same primary key (when multiple threads are writing to the same table). Any idea how I can prevent this? Do I have to perform any manual synchronization? Cheers