[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    [BUGS] BUG #3684: After dump/restore, schema PUBLIC always exists
From:       "Pedro Gimeno" <pgsql-001 () personal ! formauri ! es>
Date:       2007-10-20 9:37:07
Message-ID: 200710200937.l9K9b7Am038251 () wwwmaster ! postgresql ! org
[Download RAW message or body]


The following bug has been logged online:

Bug reference:      3684
Logged by:          Pedro Gimeno
Email address:      pgsql-001@personal.formauri.es
PostgreSQL version: 8.2.4
Operating system:   Debian Etch + Backports
Description:        After dump/restore, schema PUBLIC always exists
Details: 

In default installations (meaning those having unaltered 'template0'
databases), schema PUBLIC will exist after restoring (via psql) a pg_dump in
text mode done with -C option, even if that schema was deleted in the
original database, since it exists by default and there's no command in the
dump that deletes it. I have not tried using pg_restore or binary dumps,
though.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
[prev in list] [next in list] [prev in thread] [next in thread]