Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Pedro Gimeno <pgsql-001(at)personal(dot)formauri(dot)es>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Revisiting BUG #3684: After dump/restore, schema PUBLIC always exists
Date: 2007-11-09 23:45:57
Message-ID: 200711092345.lA9Njve13231@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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. +

In response to

pgsql-bugs by date

Next:From: Gregory StarkDate: 2007-11-10 00:13:31
Subject: Re: BUG #3737: lower/upper fails to match extended chars in LATIN1
Previous:From: Pedro GimenoDate: 2007-11-09 23:44:53
Subject: Re: Revisiting BUG #3684: After dump/restore, schema PUBLIC always exists

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group