Re: Reconstructing FKs in pg_dump - Mailing list pgsql-hackers

From Robert Treat
Subject Re: Reconstructing FKs in pg_dump
Date
Msg-id 1033074909.6610.12.camel@camel
Whole thread Raw
In response to Reconstructing FKs in pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Reconstructing FKs in pg_dump
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: [GENERAL] Performance while loading data and indexing
Next
From: Tom Lane
Date:
Subject: Re: Reconstructing FKs in pg_dump