Hi I have a dump of a large DB executed with pg_dump (schema and data together). The original schema declares some foreign keys constaints. The problem is in the pg_dump all the foreign keys disappear from the tables because thay are rendered instead as CREATE CONSTRAINT TRIGGERS. My problem is that I have to load the dump (from a 7.3) in a brand new database (8.1) and then I need to do quite a few changes to the schema dropping some old foreign constraint and adding some different ones. Since the new datadabase restored from the dump doesn't know about the old foreign keys but has just a bunch of constraint trigger, it becomes really trichy to do this kind of job. How can I tell to pg_dump to dump the schema with foreign keys construct instead of creating constraint trigger? If it's impossible what is the common practice to work arount this problem? thanks Paolo
