BUG #1222: database owner should have implicit control over public db schema

The following bug has been logged online:

Bug reference: 1222
Logged by: radim kolar

Email address: hsn(at)netmag(dot)cz

PostgreSQL version: 7.4.1

Operating system: freebsd

Description: database owner should have implicit control over public
db schema

Details:

Problem 2

Database owner should have implicit control over public schema
and over all objects in his database as well.

dbmail=> \l
List of databases
Name | Owner | Encoding
------------+-----------+-----------
dbmail | dbmail | SQL_ASCII
template0 | pgsql | SQL_ASCII
template1 | pgsql | SQL_ASCII
dbmail=> SELECT current_user;
current_user
--------------
dbmail
(1 row)
dbmail=> GRANT CREATE on SCHEMA public to public;
ERROR: permission denied for schema public
dbmail=>