From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Reconstructing FKs in pg_dump |
Date: | 2002-09-28 05:04:11 |
Message-ID: | 200209280504.g8S54B210973@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Both are done, and in CVS in /contrib/adddepend.
---------------------------------------------------------------------------
Matthew T. O'Connor wrote:
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> > However, if we are going to put that kind of knowledge into pg_dump,
> > it would only be a small further step to have it dump these triggers
> > as ALTER TABLE ADD CONSTRAINT commands instead. Which would be a lot
> > better for forward compatibility than dumping the raw triggers.
>
> There was some talk of adding Rod Taylor's identifies upgrade script to
> contrib, or mentioning it in the release. I think that it upgrades Foreign
> key, Unique, and Serial constraints, is that relevant here? Could it be
> used (or modified) to handle this situation? Just a thought.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-09-28 05:30:45 | Re: making use of large TLB pages |
Previous Message | Bruce Momjian | 2002-09-28 05:03:24 | Re: version mismatch detection doesn't work |