Re: pg_dump --clean w/ <= 7.2 server

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: pg_dump --clean w/ <= 7.2 server
Дата
Msg-id 40FDC8C2.4090409@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: pg_dump --clean w/ <= 7.2 server  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
The last patch of mine you committed just made it all DROP TABLE
public.tab;  That at least makes it work.

Chris

Bruce Momjian wrote:

> Where are we on this?
>
> ---------------------------------------------------------------------------
>
> Kris Jurka wrote:
>
>>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.


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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Patch for pg_dump: Multiple -t options and new -T option
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: [HACKERS] Point in Time Recovery