pg_dump -c doesn't order DROP TABLE correctly w.r.t inheritance - Mailing list pgsql-general

From Louis-David Mitterrand
Subject pg_dump -c doesn't order DROP TABLE correctly w.r.t inheritance
Date
Msg-id 20000531143749.A5265@styx
Whole thread Raw
List pgsql-general
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.

pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: PostgreSQL capabilities
Next
From: Henrik Ridder
Date:
Subject: No offence..but..