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

Поиск
Список
Период
Сортировка
От Louis-David Mitterrand
Тема pg_dump -c doesn't order DROP TABLE correctly w.r.t inheritance
Дата
Msg-id 20000531143749.A5265@styx
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Alex Pilosov
Дата:
Сообщение: Re: PostgreSQL capabilities
Следующее
От: Henrik Ridder
Дата:
Сообщение: No offence..but..