Re: How to change the auto pk increment to 1?

From: Todd O'Bryan (toddobrya..ac.com)
Date: Sun Jan 01 2006 - 15:31:45 EST

  • Next message: Ahmed Mohombe: "Re: How to change the auto pk increment to 1?"

    If the PK is meaningless (which, hopefully, it should be) then it
    shouldn't really matter, right? Unless you're planning a table with
    more than 200,000,000 (= MAX_INT / 20) entries, you should be okay.

    Todd

    On Dec 31, 2005, at 9:13 AM, Ahmed Mohombe wrote:

    > Hi,
    >
    > Doing several inserts in the same table with Cayenne (in different
    > transactions), it seems that the PK is incremented by 20. I
    > understood that Cayenne is doing some cache or something, but IMHO in
    > many cases this behavior is not desired at all.
    >
    > Is it possible to configure Cayenne somehow so that for the *same*
    > table the PKs are
    > incremented by *1* not 20? (the same way how Mysql or Access or
    > other autoincremented columns work in those DBs?)
    >
    > Thanks in advance,
    >
    > Ahmed.
    >

    This archive was generated by hypermail 2.0.0 : Sun Jan 01 2006 - 15:32:04 EST