On Thu, 2002-08-15 at 00:01, Christopher Kings-Lynne wrote: > > > 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
I've done the parsing of foreign key triggers required in the past for various documentation purposes and it wasn't overly fun -- nor am I sure it's right in all cases. Find 3 triggers with is_constraint true between two tables that match argument sets, split argument list by comma, first 4 aren't so useful, the rest in pairs are source / destination columns. Foreign Key state (deferred, match, etc.) is in the function naming convention. If you want to give it a shot, feel free. Whatever method is in place will need to work on 7.3 for those who didn't use a newer pg_dump on the older database. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html