Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"

Tom Lane wrote:
>
> 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?

I broke it recently: fe3b5eb08

Got a one day old guy at home, can't look at this for at least a
week, sorry.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services