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

Where are we on this?

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

Tom Lane wrote:
> Kris Jurka <books(at)ejurka(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
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