> > Dependency - have pg_dump auto-create dependencies when
> loading 7.2.X
> > data?
> >
> > Are we as far as we can go here?
>
> The only trouble maker is foreign keys. If there was a nice way of
> finding foreign keys in 7.2 and prior it probably would have been
> implemented a long time ago in pg_dump :)
What about this.
1. Implement pg_get_foreignkey_def() or whatever
2. Adjust pg_dump to dump foreign keys using an ALTER statement
3. Back port the above to rel 7_2_2
4. Release a 7.2.2 version and ask that people upgrade to that version and
do a dump before they upgrade to 7.3.
5. All is well, plus ppl who don't want to switch to 7.3 on production get
all sorts of useful bug fixes as well.
Chris