Thread: tgconstrrelid bug

tgconstrrelid bug

From
"Misha Gale"
Date:
Can anyone tell me whether the bug where the tgconstrrelid column of the
pg_triggers catalogue was ever fixed ("[BUG?] tgconstrrelid doesn't
survive a dump/restore" -
http://archives.postgresql.org/pgsql-hackers/2001-04/msg00720.php)? I am
finding some effects of this in my database, but that could be left over
from pg 7.2 (we recently switched to 7.3.) What I am really asking, is if
I chop-and-hack it back together, can I be reasonably sure it will stay
in one piece?

Thanks,

Misha Gale
--
  Misha Gale
  mishagale@fastmail.fm

--
http://www.fastmail.fm - Sent 0.000002 seconds ago

Re: tgconstrrelid bug

From
Stephan Szabo
Date:
On Wed, 8 Oct 2003, Misha Gale wrote:

> Can anyone tell me whether the bug where the tgconstrrelid column of the
> pg_triggers catalogue was ever fixed ("[BUG?] tgconstrrelid doesn't
> survive a dump/restore" -
> http://archives.postgresql.org/pgsql-hackers/2001-04/msg00720.php)? I am
> finding some effects of this in my database, but that could be left over
> from pg 7.2 (we recently switched to 7.3.) What I am really asking, is if
> I chop-and-hack it back together, can I be reasonably sure it will stay
> in one piece?

Yes.  I believe the actual bug was fixed somewhere in 7.2 time period (
I don't remember precisely), but any dumps from before that will not have
the information.