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

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