Thanks Michael, that was it. The sequences I was using were leftorvers from EOF and were advancing by 1 at a time, while Cayenne expected 20. Now everything works like a charm :).
Cheers, - hugi > On 13. okt. 2015, at 13:36, Michael Gentry <[email protected]> wrote: > > 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 you'll run into issues. > > mrg > > > On Tue, Oct 13, 2015 at 5:38 AM, Hugi Thordarson <[email protected]> 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 this? Do >> I have to perform any manual synchronization? >> >> Cheers, >> - hugi >> >> // Hugi Thordarson >> // http://www.loftfar.is/ >> // s. 895-6688 >>
