pgsql-server/src/backend/utils/adt ruleutils.c - Mailing list pgsql-committers

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@postgresql.org    03/01/08 17:54:07

Modified files:
    src/backend/utils/adt: ruleutils.c

Log message:
    Fix dumping of DEFERRABLE/INITIALLY DEFERRED:

    > The big problem is that while pg_dump's dump_trigger() looks at
    > tginitdeferred and dumps accordingly, pg_get_constraintdef doesn't look
    > at tginitdeferred, and therefore doesn't record the requirement as part
    > of ALTER TABLE ADD CONSTRAINT.

    pg_get_constraintdef should probably be looking at condeferrable and
    condeferred in the pg_constraint row it's looking at.  Maybe something
    like the attached.

    (Added, output only non-default values.)

    Stephan Szabo