Re: Postgres Sequence PK Support?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sun Mar 06 2005 - 20:02:04 EST

  • Next message: Michael Engelhart: "JBoss Transactions?"

    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.

    Andrus

    On Mar 6, 2005, at 7:40 PM, Kevin Menard wrote:
    > Hi,
    >
    > Is it possible to use a sequence for a primary key in PostgreSQL? I
    > was searching through the lists and didn't find much, but it seems as
    > though this is not possible out of the box. If not, I'll just use the
    > AUTO_PK_SUPPORT . . . I'll just have to be careful to start the values
    > high enough so they don't collide with data that's already in the DB.
    >
    > Thanks,
    > Kevin

    This archive was generated by hypermail 2.0.0 : Sun Mar 06 2005 - 20:02:11 EST