Re: pg_dump bug fixing

On Mon, 2004-07-19 at 12:36, Josh Berkus wrote:
> Rod,
> 
> > I think what we want is a clean template without all of the extras that
> > template1 has.
> 
> We have this, it's called Template0.

Doesn't work for me. I remove a number of things that are included by
default in template0, but yes, it's close.

> Actually, KL, that would solve a lot of these duplicate object problems.  What 
> if pg_restore used Template0 and not Template1?    It wouldn't fix the "drop 
> public schema" issue but it would solve the others.

Remove the public schema from template0, but leave it in template1. Have
pg_dump treat the public schema the same as all of the other ones.