On Sat, Jun 11, 2011 at 8:01 PM, Robert Haas <robertmh...@gmail.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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
