pg_dump --clean w/ <= 7.2 server

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема pg_dump --clean w/ <= 7.2 server
Дата
Msg-id Pine.BSO.4.56.0406240722080.3872@leary.csoft.net
обсуждение исходный текст
Ответы Re: pg_dump --clean w/ <= 7.2 server  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: pg_dump --clean w/ <= 7.2 server  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
When running pg_dump --clean against a server that doesn't have schemas
the namespace is blank and ends up producing a dump full off things like:

DROP TABLE "".tab;

The attached patch only includes a schema if one exists.  There are
numerous comments about the DROPs needing to be fully qualified to avoid
conflicting with pg_catalog, but this should be mostly safe because it
would require a user defined object to be present in a later server
version with the same name, and it is difficult to impossible to drop
system objects anyway.

Kris Jurka

Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Include tablespace information in psql \d footers
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: pg_dump --clean w/ <= 7.2 server