BUG #12008: REASSIGN OWNED changes other databases

Поиск
Список
Период
Сортировка
От carlos.vasquez@clearcorp.co.cr
Тема BUG #12008: REASSIGN OWNED changes other databases
Дата
Msg-id 20141119183721.2476.90123@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #12008: REASSIGN OWNED changes other databases  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12008
Logged by:          Carlos Vásquez
Email address:      carlos.vasquez@clearcorp.co.cr
PostgreSQL version: 9.3.5
Operating system:   Ubuntu 14.04
Description:

Bug explained in stackoverflow
(http://stackoverflow.com/questions/27003415/postgres-reassign-owned-for-only-1-database).

I am using package 9.3.5-0ubuntu0.14.04.1 in ubuntu 14.04 without any
modification.

If I have multiple databases owned by user1 and I run REASSIGN OWNED BY
user1 TO user2; in 1 specific database, the command also changes the owner
of the other databases that user1 owns. This affects only the databases, not
the objects inside. Only the objects in the open database get changed to
user2 as it should be.

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

Предыдущее
От: bashtanov@imap.cc
Дата:
Сообщение: BUG #12011: information_schema.constraint_column_usage is slow
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #12008: REASSIGN OWNED changes other databases