BUG #13809: Reassign owned throws error

From: alexander(dot)ashurkov(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13809: Reassign owned throws error
Date: 2015-12-09 11:26:42
Message-ID: 20151209112642.876.19827@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13809
Logged by: Alexander Ashurkov
Email address: alexander(dot)ashurkov(at)gmail(dot)com
PostgreSQL version: 9.4.5
Operating system: Linux 3.19.0-31-generic #36~14.04.1-Ubuntu SMP Thu
Description:

Hello,
when I execute "reassign owned by user to user_role" command (even with
'postgres' user) postgresql outputs this message:
"ERROR: unexpected classid 1418
SQL state: XX000"

My DB has postgresql FDW (it owned by 'postgres' user as it should be), one
foreign server (owned by 'user_role') and two user mappings for 'user' and
'user_role'.

'user' is member of 'user_role' ('GRANT user_role TO user').

Postgresql installed from "deb http://apt.postgresql.org/pub/repos/apt/
trusty-pgdg main" repo.

With version 9.4.4 it worked fine. Do I miss something or it is a bug?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message filip 2015-12-09 14:07:08 BUG #13810: cursor_to_xml ignores tableforest parameter
Previous Message tarunt 2015-12-09 09:01:53 BUG #13808: Upsert not working