Re: Reconstructing FKs in pg_dump

On Thu, 2002-09-26 at 16:57, Tom Lane wrote:
<snip>
> There are a couple things I think we should do.  One: modify the CREATE
> CONSTRAINT TRIGGER code to try to extract a foreign relation name from
> the tgargs if FROM is missing.  Without this, we have no hope of loading
> working FK trigger definitions from old dumps.  Two: modify pg_dump to
> extract a name from the tgargs in the same fashion.  I'd rather have
> pg_dump do this than the backend, and this will at least make things
> better in the case where you're using a 7.3 pg_dump against an older
> database.
<snip>
> 
> Thoughts?
> 

I'm trying to think of the cases where this extraction might fail, but
maybe more important is what happens if it does fail? 

Robert Treat