Horton
Menu

Re: [BUG?] tgconstrrelid doesn't survive a dump/restore

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joel Burton <jburton@scw.org>
Cc: pgsql-hackers@postgresql.org, Philip Warner <pjw@rhyme.com.au>, JanWieck@Yahoo.com
Date: 2001-04-18T20:30:53Z
Lists: pgsql-hackers 
Joel Burton <jburton@scw.org> writes:
> Do we know if the problem is in pg_dump, or is there no way
> to pass the tgconstrrelid value in the CREATE CONSTRAINT TRIGGER
> statement?

IIRC, pg_dump is just failing to transfer the value; it needs to emit
an additional clause in the CREATE CONSTRAINT command to do so.

			regards, tom lane