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

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump -c doesn't order DROP TABLE correctly w.r.t inheritance
Date: 2000-05-31 12:37:49
Message-ID: 20000531143749.A5265@styx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)apartia(dot)org - http://www.apartia.fr

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

Browse pgsql-general by date

  From Date Subject
Next Message Henrik Ridder 2000-05-31 13:07:56 No offence..but..
Previous Message Peter Eisentraut 2000-05-31 11:11:17 Re: pg_hba.conf and password/crypt authorization