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

On Sun, Dec 9, 2012 at 11:13 PM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> 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
>

whatever is the right way to solve this... shouldn't we do something
similar in shdepReassignOwned() in which we are still ignoring shared
objects?

--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157