Re: Revisiting BUG #3684: After dump/restore, schema PUBLIC always exists

Pedro Gimeno wrote:
> Bruce Momjian wrote:
>
> > The fact is that 'public' is created from template1, so I suppose if
> > you remove it from there then new databases will not have it.
>
> That could cause installers for packages using PostgreSQL to fail if
> they create databases and expect "public" to exist.
>
> Furthermore I make my dumps with option -C for pg_dump. The CREATE
> DATABASE statement it generates uses template0 as the template.

I don't think so. I think it uses template1.

> > I think it would be odd for pg_dump to remove something that was in
> > the database before the restore started. I am afraid removing it
> > yourself is the only logical option for us.
>
> If that's really the case then please add a note in the docs stating
> that deleted objects may revive, so it's no surprise for those who face
> that for the first time.

You are the first person every to have reported surprise to us, so I am
not inclined to add a documentation until I hear it is a more general
problem.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +