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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joel Burton <jburton(at)scw(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org, Philip Warner <pjw(at)rhyme(dot)com(dot)au>, JanWieck(at)Yahoo(dot)com
Subject: Re: [BUG?] tgconstrrelid doesn't survive a dump/restore
Date: 2001-04-18 20:30:53
Message-ID: 14424.987625853@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joel Burton <jburton(at)scw(dot)org> writes:
> Do we know if the problem is in pg_dump, or is there no way
> to pass the tgconstrrelid value in the CREATE CONSTRAINT TRIGGER
> statement?

IIRC, pg_dump is just failing to transfer the value; it needs to emit
an additional clause in the CREATE CONSTRAINT command to do so.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Myers 2001-04-18 20:49:43 Re: CRN article not updated
Previous Message Peter Eisentraut 2001-04-18 20:25:24 Re: Re: No printable 7.1 docs?