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

From Bruce Momjian
Subject Re: pg_dump --clean w/ <= 7.2 server
Date
Msg-id 200407201900.i6KJ0MB14182@candle.pha.pa.us
Whole thread Raw
In response to pg_dump --clean w/ <= 7.2 server  (Kris Jurka <books@ejurka.com>)
Responses Re: pg_dump --clean w/ <= 7.2 server  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-patches
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.
>
> Kris Jurka

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: logfile subprocess and Fancy File Functions
Next
From: Peter Eisentraut
Date:
Subject: Re: logfile subprocess and Fancy File Functions