Tom Lane wrote:
>=20
> spam_eater@gmx.net writes:
> > postgres=3D# create user testuser with password 'secret';
> > CREATE ROLE
> > postgres=3D# create database testdb owner testuser;
> > CREATE DATABASE
> > testdb=3D> drop owned by testuser;
> > ERROR: unrecognized object class: 1262
>=20
> 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?
I broke it recently: fe3b5eb08
Got a one day old guy at home, can't look at this for at least a
week, sorry.
--=20
=C1lvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services