Re: postgres PK serial column insert error

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Sep 27 2004 - 11:21:26 EDT

  • Next message: McDaniel, Joe: "Re: filtering to-many relationship list"

    On Sep 27, 2004, at 8:27 AM, Jason Dwyer wrote:

    > i actually though this was a thing of the past, as the jdbc spec gives
    > the flexibility to collect the generated keys straight after an
    > insert/update.
    >
    > i never liked the 'controller' table implementation: particularly nasty
    > if you have a couple of independent apps hooking into the same db, or a
    > cluster of appservers hooking into the one db.

    Looks like you are referring to the autoincrement columns feature. JDBC
    does support that (though there are driver limitations on some DBs).
    Supporting autoincrement in Cayenne is on top of the feature list for
    version 1.2 - it will be there very soon.

    But don't write off "auto_pk_table" just yet - Cayenne should (and
    will) support all db schemas, without making assumptions of any single
    design approach.

    Andrus



    This archive was generated by hypermail 2.0.0 : Mon Sep 27 2004 - 11:21:33 EDT