I am starting to use inheritance between tables and when performing a pg_dump -c (ie: clean drop schema) the DROP TABLE statements are not optimally ordered: the "DROP TABLE mother_table" comes before "DROP TABLE child_table" and a "psql -f dump.sql" fails to clear the tables because you can't DROP a table when a child table isn't droped beforehand. -- Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.fr I would like to meet the guy who invented sex, just to see what he's working on now.