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(at)postgresql(dot)org

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