]> granicus.if.org Git - postgresql/commit
Fix dumping of DEFERRABLE/INITIALLY DEFERRED:
authorBruce Momjian <bruce@momjian.us>
Wed, 8 Jan 2003 22:54:06 +0000 (22:54 +0000)
committerBruce Momjian <bruce@momjian.us>
Wed, 8 Jan 2003 22:54:06 +0000 (22:54 +0000)
commitd31b20af693dfc3bc483d1e1680dbc5ce4348c18
tree39f70f369af21224eb8ae515f3c0c7a2c97290d8
parent5e36cbe6ee56f10ded66af59919c9a1cae6b0d80
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
src/backend/utils/adt/ruleutils.c