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 40DADDFE.4030106@familyhealth.com.au
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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
> 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;

Since the person is dumping using 7.5 pg_dump, presumably they will be
restoring to 7.5, and it should be:

DROP TABLE "public".tab;

Chris


pgsql-patches by date:

Previous
From: Kris Jurka
Date:
Subject: pg_dump --clean w/ <= 7.2 server
Next
From: Tom Lane
Date:
Subject: Re: pg_dump --clean w/ <= 7.2 server