cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: interactions with PostgreSQL sequences
Date Thu, 07 Sep 2006 11:41:42 GMT

On Sep 7, 2006, at 3:32 PM, Arturo PĂ©rez wrote:

> The
> sequence was created like:
>
> CREATE SEQUENCE pk_article INCREMENT 1 START 200
> ;
>
> so I need to redo that with a INCREMENT 20?

Ok, "INCREMENT 1" explains the mismatch. You can either redo the  
sequences changing the increment, or edit "PK Generation Strategy"  
for each entity, selecting "Custom Sequence" with "Cached PK Size" of  
1 (which will work, but result in more trips to db on insert).

Andrus

Mime
View raw message