Re: pg_dump --clean w/ <= 7.2 server - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: pg_dump --clean w/ <= 7.2 server
Date
Msg-id 40FDC8C2.4090409@familyhealth.com.au
Whole thread Raw
In response to Re: pg_dump --clean w/ <= 7.2 server  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Patch for pg_dump: Multiple -t options and new -T option
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [HACKERS] Point in Time Recovery