Re: New objects break FK constraints

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Jan 29 2004 - 20:18:18 EST

  • Next message: Scott Ellsworth: "Re: Confusion about writable to-many relationships"

    On Jan 29, 2004, at 12:51 PM, Arndt Brenschede wrote:

    > What I wanted to try is to use
    > the "DEFERRED" mode of the constraint,
    > where it is checked at commit time,
    > not at update time.

    I know this works on Oracle. Jim is on PostgreSQL. I just checked the
    docs for 7.4, and bingo - constraints can be defined as deferred:

    http://www.postgresql.org/docs/current/static/sql-createtable.html

    Since CayenneModeler does not have this setting, you will need to alter
    generation scripts to add "DEFRRED" option at least to the set of
    circular relationships that we discussed.

    Andrus

    This archive was generated by hypermail 2.0.0 : Thu Jan 29 2004 - 20:18:23 EST