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

From Tom Lane
Subject Re: pg_dump --clean w/ <= 7.2 server
Date
Msg-id 28045.1088114005@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump --clean w/ <= 7.2 server  (Kris Jurka <books@ejurka.com>)
Responses Re: pg_dump --clean w/ <= 7.2 server  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Kris Jurka <books@ejurka.com> writes:
>> Possibly the most correct solution is to assign the name "public" to the
>> dummy schema that pg_dump creates internally when talking to a pre-7.3
>> server.

> I was considering that they might want to restore the dump into another
> schema and that would be easier with an unqualified name.  I don't really
> understand why the name needs to be fully qualified in the first place.

Because it's entirely too likely that you'll drop the wrong thing if you
issue an unqualified DROP.

            regards, tom lane

pgsql-patches by date:

Previous
From: Kris Jurka
Date:
Subject: Re: pg_dump --clean w/ <= 7.2 server
Next
From: Dennis Bjorklund
Date:
Subject: Add argument name to CREATE FUNCTION documentation