> 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 :) Something in the release notes about how the foreign key dependency stuff only works if they drop all current foreign keys (drop trigger) and re-add them via alter table add foreign key is suggested. Worst case scenario for Foreign keys is they will have what they always had. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster