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

2001-04-18 Thread Joel Burton
tgconstrrelid (in pg_trigger) holds table references in a RI trigger. The value in this field is not successfully recreated after a dump/restore. --- If I create a simple relationship: create table p (id int primary key); create table c (pid int references p); and query the system

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

2001-04-18 Thread Tom Lane
Joel Burton [EMAIL PROTECTED] 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