I remember that happening to me way back in Cayenne 1.x when I converted over from EOF. I wonder if there's any way we can make this more obvious to the end-user who migrates from EOF? Hugi, was there any particular place where we could have documented this where it would have become obvious to you during the migration?
On Tue, Oct 13, 2015 at 9:55 AM, Hugi Thordarson <h...@karlmenn.is> wrote: > 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 <mgen...@masslight.net> 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 <h...@karlmenn.is> 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 >>> >