"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Database owner should have implicit control over public schema
> and over all objects in his database as well.
The former is debatable, the latter simply wrong. Make the DB owner a
superuser if you want him to have absolute privileges.
There has been some discussion of causing the public schema to be owned
by the DB owner, but this has not happened yet, partly because we are
not sure of all the consequences.
regards, tom lane