spam_eater(at)gmx(dot)net writes:
> postgres=# create user testuser with password 'secret';
> CREATE ROLE
> postgres=# create database testdb owner testuser;
> CREATE DATABASE
> testdb=> drop owned by testuser;
> ERROR: unrecognized object class: 1262
I can reproduce this in all versions back to 8.3. In 8.2, the role's
ownership of the database is silently ignored, which I think was the
design intention. I doubt that we want DROP OWNED dropping whole
databases. At most maybe we should raise a NOTICE?
regards, tom lane