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 200407110313.i6B3DY525123@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_dump --clean w/ <= 7.2 server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Where are we on this?

---------------------------------------------------------------------------

Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

--
  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: [pgsql-hackers-win32] Data directory with trailing [back]slash
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: OWNER TO mega patch #2