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.
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2002-09-28 04:39:27|
|Subject: version mismatch detection doesn't work|
|Previous:||From: Martijn van Oosterhout||Date: 2002-09-28 02:05:58|
|Subject: Re: query speed depends on lifetime of frozen db?|