pgsql-server/src/backend/utils/adt Tag: REL7_3 ...
pgsql-server/src/backend/utils/adt Tag: REL7_3 ...
От:
momjian@postgresql.org (Bruce Momjian - CVS)
Дата:
CVSROOT: /cvsroot Module name: pgsql-server Changes by: momjian@postgresql.org 03/01/08 17:54:36 Modified files: src/backend/utils/adt: Tag: REL7_3_STABLE 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