On Sun, Dec 9, 2012 at 11:13 PM, Alvaro Herrera <[email protected]> wrote: > Tom Lane wrote: >> >> [email protected] 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
