Re: Postgres Sequence PK Support?

From: Michael Engelhart (moosebrookfar..mail.com)
Date: Tue Mar 08 2005 - 10:10:58 EST

  • Next message: Michael Engelhart: "Serialization questions"

    I too will test this out. One question I have (sorry new to Cayenne)
    is in the patch it hard codes the sequence start value at 200? Why
    isn't that an optional value. Also when you're using a legacy
    PostgreSQL sequence, why not allow the option to use existing
    sequences. As I said I'm a newbie so I don't know if there is another
    way to do this. Is there?

    Thanks
    Mike

    On Tue, 08 Mar 2005 13:28:01 +1030, shaun <wojing..astmail.com.au> wrote:
    > On Mon, 2005-03-07 at 21:00 -0500, Kevin Menard wrote:
    > > On 3/6/05 8:02 PM, "Andrus Adamchik" <andru..bjectstyle.org> wrote:
    > >
    > > > Meant to switch PostgresAdapter to use sequences for some time...
    > > > AUTO_PK_SUPPORT seems too "mysql style" :-) If you can hack a
    > > > Postgres-friendly PkGenerator based on Oracle or DB2 version, please
    > > > contribute via JIRA.
    > >
    > > I've done up a patch and created a JIRA issue. Normally I'd save this for
    > > the devel list, but if anyone here uses Postgres, they may interested in
    > > trying it out.
    > >
    > > http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-287
    > >
    >
    > Thanks Kevin. I will be doing some work with Postgresql very soon, so
    > I'll give it a shot.
    >
    > regards,
    > shaun
    >
    >

    This archive was generated by hypermail 2.0.0 : Tue Mar 08 2005 - 10:11:01 EST