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

reassign owned to change the ownership for op class and family

From: Asko Tiidumaa <asko(dot)tiidumaa(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: reassign owned to change the ownership for op class and family
Date: 2010-07-01 15:19:46
Message-ID: AANLkTimEWxxsoab2mwAhJNlzCVUmXsr2FXUbBTAwkgAi@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Currently REASSIGN OWNED complains "unexpected classid" for operator
class and family.

For example,

create two users, user1 and user2

under user1:
create type oxetype as enum ('oxe1');
create operator class oxeops
default for type oxetype using btree as
function 1 array_lower(anyarray,integer);

and then observe "unexpected classid" error:
reassign owned by user1 to user2

So I propose a patch that goes against head, and it would be great to
get it backported to at least 8.3 branch

Comments?


Asko Tiidumaa
---
Skype, Sr DBA

Attachment: reassign_owned_opclass_opfamily.diff
Description: application/octet-stream (3.4 KB)

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-07-01 15:21:26
Subject: Re: bitmap indexes - performance
Previous:From: Robert HaasDate: 2010-07-01 15:04:30
Subject: Re: bitmap indexes - performance

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