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

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

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>

Date: 2001-04-18T18:38:58Z

Lists: pgsql-hackers

Joel Burton <jburton@scw.org> writes:
> tgconstrrelid (in pg_trigger) holds table references in a RI trigger.
> The value in this field is not successfully recreated after a
> dump/restore.

Yes, this problem was noted a couple months ago.  AFAIK it was not fixed
for 7.1, but I concur that it should be fixed.

			regards, tom lane