Re: PK problem with Postgre

From: Mike Kienenberger (mkienen..mail.com)
Date: Thu Apr 20 2006 - 10:32:06 EDT

  • Next message: WONDER: "Re: PK problem with Postgre"

    On 4/20/06, Bryan Lewis <brya..aine.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.



    This archive was generated by hypermail 2.0.0 : Thu Apr 20 2006 - 10:32:33 EDT