Re: BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres - Mailing list pgsql-bugs

xelah-postgresql@xelah.com writes:
> 'CREATE DATABASE .. OWNER ..' creates a database owned by the correct user,
> but containing a schema apparently owned by the user running 'CREATE
> DATABASE'. This causes us a problem when our test code tries to 'DROP SCHEMA
> public CASCADE' (as a way of clearing the database) as the database owner.

Yes, the public schema remains owned by the bootstrap superuser.  That's
intentional.  If you don't want to have that schema, you can drop it,
but you need superuser privileges to do so.

            regards, tom lane