Re: wrong message on REASSIGN OWNED

On Sat, Jun 11, 2011 at 8:01 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>
> "can't reassign objects owned by %s because this user is internal to
> the database system" ?
>

that message is not that clear... it seems to imply i can't reassign
any object from that user...

btw, i'm allowed to use ALTER TABLE to assign a new owner (even an
unprivileged one) to a system catalog, probably that's a bug.

db=# create role unprivileged_user login;
CREATE ROLE
db=# alter table pg_class owner to unprivileged_user ;
ALTER TABLE
db=# \dt pg_class
List of relations
Schema | Name | Type | Owner
------------+----------+-------+-------------------
pg_catalog | pg_class | table | unprivileged_user
(1 row)

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación