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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html