Re: PK problem with Postgre

From: WONDER (mmmmmmmmm5..eb.de)
Date: Thu Apr 20 2006 - 11:01:16 EDT

  • Next message: Andrus Adamchik: "Re: Bug in cayenne 1.2B1 and 1.2B2"

    In general does not make any diffrence. This is interresting if I have more
    than one application insert in the same table.
    however, I dont think this makes problems.

    thx

    ----- Original Message -----
    From: "Mike Kienenberger" <mkienen..mail.com>
    To: <cayenne-use..ncubator.apache.org>
    Sent: Thursday, April 20, 2006 4:32 PM
    Subject: 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 - 11:01:22 EDT