BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type

Поиск
Список
Период
Сортировка
От cpacejo@clearskydata.com
Тема BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type
Дата
Msg-id 20151007142530.8425.57690@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13666
Logged by:          Chris Pacejo
Email address:      cpacejo@clearskydata.com
PostgreSQL version: 9.4.4
Operating system:   CentOS 7 (kernel 3.10.0-123.el7.x86_64)
Description:

=# CREATE TYPE foo AS (a integer, b integer);

=# ALTER TYPE foo OWNER TO user1;

=# SELECT typowner, relowner FROM pg_type JOIN pg_class ON typrelid =
relfilenode WHERE typname = 'foo';
-[ RECORD 1 ]---
typowner | 16384
relowner | 16384

=# REASSIGN OWNED BY user1 TO user2;

=# SELECT typowner, relowner FROM pg_type JOIN pg_class ON typrelid =
relfilenode WHERE typname = 'foo';
-[ RECORD 1 ]---
typowner | 8713825
relowner | 16384


This prevents user2 from being able to modify 'foo':

=> ALTER TYPE foo RENAME ATTRIBUTE b TO c;
ERROR:  must be owner of relation foo


Furthermore, while trying to replicate in another database, I encountered:

=# REASSIGN OWNED BY user1 TO user2;
ERROR:  unexpected classid 1418

Not sure if this is related or not.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Chris Pacejo
Дата:
Сообщение: Re: BUG #13660: serializable snapshotting hangs
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type