cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "WONDER" <mmmmmmmm...@web.de>
Subject Re: PK problem with Postgre
Date Thu, 20 Apr 2006 15:14:17 GMT
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" <mkienenb@gmail.com>
> To: <cayenne-user@incubator.apache.org>
> Sent: Thursday, April 20, 2006 4:32 PM
> Subject: Re: PK problem with Postgre
>
>
> On 4/20/06, Bryan Lewis <bryan@maine.rr.com> 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.
>
>


Mime
View raw message