I changed the "INCREMENT BY 1" into "INCREMENT BY 3" in PostGreSQL. The cayenne still increments by 1. I think the default PK strategy does not use the seq correctly.
> ----- Original Message ----- > From: "Mike Kienenberger" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, April 20, 2006 4:32 PM > Subject: Re: PK problem with Postgre > > > On 4/20/06, Bryan Lewis <[EMAIL PROTECTED]> wrote: > > Here's my guess. Your image table had some existing data before you > > added the sequence for Cayenne's use. When the modeler adds a sequence, > > it defaults to a starting value of 200, with SQL like this: > > > > CREATE SEQUENCE pk_image START WITH 200 INCREMENT BY 20; > > Another thing to keep in mind is that EOF defaults to "INCREMENT BY 1" > while Cayenne defaults to "INCREMENT BY 20". Not sure if it'll have > any bearing on your situation. > >
