Skip site navigation (1) Skip section navigation (2)

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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kirill Simonov <xi(at)gamma(dot)dn(dot)ua>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4132: REASSIGN OWNED fails on procedural languages
Date: 2008-04-29 19:20:23
Message-ID: 20080429192023.GH5652@alvh.no-ip.org (view raw or flat)
Thread:
Lists: 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.

In response to

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2008-04-29 19:25:36
Subject: Re: BUG #4132: REASSIGN OWNED fails on procedural languages
Previous:From: Kirill SimonovDate: 2008-04-29 18:42:45
Subject: BUG #4132: REASSIGN OWNED fails on procedural languages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group