Re: BUG #4132: REASSIGN OWNED fails on procedural languages

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #4132: REASSIGN OWNED fails on procedural languages
Дата
Msg-id 20080429192023.GH5652@alvh.no-ip.org
обсуждение исходный текст
Ответ на BUG #4132: REASSIGN OWNED fails on procedural languages  ("Kirill Simonov" <xi@gamma.dn.ua>)
Ответы Re: BUG #4132: REASSIGN OWNED fails on procedural languages  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
Kirill Simonov wrote:

> In Postgresql 8.3, one can assign owners to procedural languages using
> "ALTER LANGUAGE ... OWNER TO ...".  However the command "REASSIGN OWNED ...
> TO ...", which reassigns the owner of all objects owned by a particular
> user, fails if the user owns a procedural language.  The error message is
> "unexpected classid 2612", which is the class id of pg_language.

Thanks for the report.  Apparently no one noticed when the new ALTER
LANGUAGE capability was added.

The attached patch should fix the problem.  I'm going to commit to 8.3
and HEAD in a jiffy.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: "Kirill Simonov"
Дата:
Сообщение: BUG #4132: REASSIGN OWNED fails on procedural languages
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #4132: REASSIGN OWNED fails on procedural languages