Re: pg_dumpall (7.3) 'public' schema bug

On 2004.11.16 16:25 Tom Lane wrote:
> "Karl O. Pinc" <kop(at)meme(dot)com> writes:
> > I deleted the 'public' schema from my databases
> > in 7.3, now in 7.4 they are back.
>
> IMHO this is not a bug. It is not pg_dump's charter to remove
> system-created objects...

I can live with this, but I find the implication distasteful --
that there is no way to move a database from one cluster
to another and have an exact copy. Not even when both
clusters are running the same release.

I don't care that much about the behavior, it's easy enough
to delete 'public'. I do think that a note should be
made in the administrator manual regards system upgrades
where pg_dump(all) scripts are given if this is going to be
the behavior.

Thanks for postgresql.

Karl <kop(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein