Re: interactions with PostgreSQL sequences

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Sep 07 2006 - 07:41:42 EDT

  • Next message: Eric Lazarus: "JDBCRealm alternatives... is there a Cayenne Realm around I could use?"

    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

    This archive was generated by hypermail 2.0.0 : Thu Sep 07 2006 - 07:42:04 EDT