Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUG?] tgconstrrelid doesn't survive a dump/restore - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [BUG?] tgconstrrelid doesn't survive a dump/restore
Date
Msg-id 12407.987619138@sss.pgh.pa.us
Whole thread Raw
In response to [BUG?] tgconstrrelid doesn't survive a dump/restore  (Joel Burton <jburton@scw.org>)
Responses Re: [BUG?] tgconstrrelid doesn't survive a dump/restore  (Joel Burton <jburton@scw.org>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "P. A. Bagyenda"
Date:
Subject: problems with corrupted db on v7.0.3 on linux 2.2.x
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: AW: timeout on lock feature