| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Reconstructing FKs in pg_dump |
| Date: | 2002-09-26 21:15:05 |
| Message-ID: | 1033074909.6610.12.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-09-26 21:17:30 | Re: [HACKERS] Performance while loading data and indexing |
| Previous Message | Rod Taylor | 2002-09-26 21:12:09 | Re: Reconstructing FKs in pg_dump |