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

BUG #4132: REASSIGN OWNED fails on procedural languages

From: "Kirill Simonov" <xi(at)gamma(dot)dn(dot)ua>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4132: REASSIGN OWNED fails on procedural languages
Date: 2008-04-29 18:42:45
Message-ID: 200804291842.m3TIgjes061529@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4132
Logged by:          Kirill Simonov
Email address:      xi(at)gamma(dot)dn(dot)ua
PostgreSQL version: 8.3.1
Operating system:   FreeBSD
Description:        REASSIGN OWNED fails on procedural languages
Details: 

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.

Here is a snippet of code for reproducing this problem:

CREATE USER original_owner SUPERUSER;
CREATE USER new_owner SUPERUSER;

CREATE LANGUAGE plpgsql;
ALTER LANGUAGE plpgsql OWNER TO original_owner;

REASSIGN OWNED BY original_owner TO new_owner;

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2008-04-29 19:20:23
Subject: Re: BUG #4132: REASSIGN OWNED fails on procedural languages
Previous:From: Karsten DeslerDate: 2008-04-29 11:51:40
Subject: Re: postmaster segfault when using SELECT on a table

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