Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type
Date
Msg-id 20151211215445.GW2763@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Alvaro Herrera wrote:
> cpacejo@clearskydata.com wrote:

> > Furthermore, while trying to replicate in another database, I encountered:
> >
> > =# REASSIGN OWNED BY user1 TO user2;
> > ERROR:  unexpected classid 1418
> >
> > Not sure if this is related or not.
>
> Not related.  1418 is pg_user_mapping (FDW stuff).  Not sure what should
> happen here; my inclination without thinking too hard is that REASSIGN
> OWNED should ignore that object and DROP OWNED should remove it.

Ouch, I just noticed that you had already reported this months ago, and
I was even aware of it!  I just pushed a fix for it without mentioning
you as first reporter :-(

I'm now looking at the other problem you reported here.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: "michael@sqlexec.com"
Date:
Subject: Re: BUG #13804: pg_restore returns unexpected error
Next
From: "michael@sqlexec.com"
Date:
Subject: Re: BUG #13804: pg_restore returns unexpected error