Re: pg_dumpall (7.3) 'public' schema bug

On 2004.11.16 16:25 Tom Lane wrote:
> "Karl O. Pinc" <kop@meme.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@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein