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.