Thread: pg_dump -c doesn't order DROP TABLE correctly w.r.t inheritance

pg_dump -c doesn't order DROP TABLE correctly w.r.t inheritance

From
Louis-David Mitterrand
Date:
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 - ldm@apartia.org - http://www.apartia.fr

I would like to meet the guy who invented sex, just to see what he's
working on now.