dbTalk Databases Forums  

[BUGS] tgconstrrelid bug

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] tgconstrrelid bug in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Misha Gale
 
Posts: n/a

Default [BUGS] tgconstrrelid bug - 10-08-2003 , 06:54 AM






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...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 (AT) fastmail (DOT) fm

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Reply With Quote
  #2  
Old   
Stephan Szabo
 
Posts: n/a

Default Re: [BUGS] tgconstrrelid bug - 10-08-2003 , 09:48 AM






On Wed, 8 Oct 2003, Misha Gale wrote:

Quote:
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...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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.