Reassigned Owned Error- unexpected classid 2328

Lists: pgsql-general
From: pcasper <pcasper(at)wp(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Reassigned Owned Error- unexpected classid 2328
Date: 2012-02-15 16:03:54
Message-ID: 1329321834554-5486492.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hi,

During execute follow statement to reassign owner of objects in the database
I have an error:
unexpected classid 2328

Statement:
REASSIGN OWNED BY olduser TO postgres;

Regards,

Pawel

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Reassigned-Owned-Error-unexpected-classid-2328-tp5486492p5486492.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pcasper <pcasper(at)wp(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Reassigned Owned Error- unexpected classid 2328
Date: 2012-02-15 17:54:18
Message-ID: 29019.1329328458@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

pcasper <pcasper(at)wp(dot)pl> writes:
> During execute follow statement to reassign owner of objects in the database
> I have an error:
> unexpected classid 2328

Hm, that would be a foreign data wrapper ... looks like REASSIGN OWNED
is missing support for that type of object. For the moment, you'll need
to alter the owner manually.

regards, tom lane