On Sun, Dec 9, 2012 at 11:13 PM, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > Tom Lane wrote: >> >> spam_ea...@gmx.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
