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

Alvaro Herrera escribió:

> On the other hand, running REASSIGN OWNED means to reassign ownership of
> objects to some other user. There is no reason this cannot be done to
> shared objects as well as local objects. I note, though, that REASSIGN
> OWNED's documentation mentions "objects in the current database"; but in
> spirit, the point of it is to drop users. So applying to shared objects
> seems within charter to me.

FWIW, the docs for REASSIGN OWNED have a note at the bottom:
"The REASSIGN OWNED command does not affect the ownership of any
databases owned by the role."

This was added because Josh Berkus commanded us to:
http://www.postgresql.org/message-id/4BE2367C.30605@agliodbs.com

As far as I'm concerned, that note should be removed. Also, there's
this bit:

"Because REASSIGN OWNED only affects the objects in the current
database, it is usually necessary to execute this command in each
database that contains objects owned by a role that is to be removed."

This would be reworded thusly:

"Because REASSIGN OWNED does not affect objects in other
databases, it is usually necessary to execute this command in each
database that contains objects owned by a role that is to be removed."

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