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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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 Content-Type Size
reassign_owned_opclass_opfamily.diff application/octet-stream 3.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-07-01 15:21:26 Re: bitmap indexes - performance
Previous Message Robert Haas 2010-07-01 15:04:30 Re: bitmap indexes - performance