Re: tgconstrrelid bug - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: tgconstrrelid bug
Date
Msg-id 20031008074303.Y87798@megazone.bigpanda.com
Whole thread Raw
In response to tgconstrrelid bug  ("Misha Gale" <mishagale@fastmail.fm>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: "Misha Gale"
Date:
Subject: tgconstrrelid bug
Next
From: Tom Lane
Date:
Subject: Re: Unpredictable signal 11 crashes on Mac OS X