I believe I found a bug. If a user other than the postgres superuser is
given permission to create databases, then he should be able to destroy
the databases he creates. Currently he can't, at least in version 6.2.1
complied for SunOS 5.5. Only the poostgres superuser can delete
databases. If otherusers try they get the following error message:
"WARN:pg_database: Permission denied.
destroydb: database destroy failed on tmpdb."
eventhough this user is the database admin for tmpdb as shown in the
pd_database table.