Thread: BUG #6593: REASSIGN OWNED fails on extensions
The following bug has been logged on the website: Bug reference: 6593 Logged by: Emiliano Leporati Email address: emiliano.leporati@gmail.com PostgreSQL version: 9.1.2 Operating system: FreeBSD 9.0 Description:=20=20=20=20=20=20=20=20 Steps to reproduce: postgres=3D# create database failtest; CREATE DATABASE postgres=3D# \c failtest You are now connected to database "failtest" as user "ubik". failtest=3D# create extension citext; CREATE EXTENSION failtest=3D# create table foo(bar integer); CREATE TABLE failtest=3D# reassign owned by ubik to dev; ERROR: unexpected classid 3079 failtest=3D# select relname from pg_class where oid =3D 3079; relname -------------- pg_extension (1 row) failtest=3D#
Excerpts from emiliano.leporati's message of lun abr 16 06:21:53 -0300 2012: > failtest=3D# create extension citext; > CREATE EXTENSION > failtest=3D# create table foo(bar integer); > CREATE TABLE > failtest=3D# reassign owned by ubik to dev; > ERROR: unexpected classid 3079 Will fix. --=20 =C3=81lvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Excerpts from Alvaro Herrera's message of mi=C3=A9 abr 18 12:02:25 -0300 20= 12: > Excerpts from emiliano.leporati's message of lun abr 16 06:21:53 -0300 20= 12: >=20 > > failtest=3D# create extension citext; > > CREATE EXTENSION > > failtest=3D# create table foo(bar integer); > > CREATE TABLE > > failtest=3D# reassign owned by ubik to dev; > > ERROR: unexpected classid 3079 >=20 > Will fix. Just pushed a fix. Sorry it took so long to get it out. --=20 =C3=81lvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Nice, thank you ! on humble behalf of every dba / pg lover. On Tue, Jul 3, 2012 at 9:22 PM, Alvaro Herrera <alvherre@commandprompt.com>wrote: > > Excerpts from Alvaro Herrera's message of mi=E9 abr 18 12:02:25 -0300 201= 2: > > Excerpts from emiliano.leporati's message of lun abr 16 06:21:53 -0300 > 2012: > > > > > failtest=3D# create extension citext; > > > CREATE EXTENSION > > > failtest=3D# create table foo(bar integer); > > > CREATE TABLE > > > failtest=3D# reassign owned by ubik to dev; > > > ERROR: unexpected classid 3079 > > > > Will fix. > > Just pushed a fix. Sorry it took so long to get it out. > > -- > =C1lvaro Herrera <alvherre@commandprompt.com> > The PostgreSQL Company - Command Prompt, Inc. > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > --=20 Emiliano Leporati E-mail: emiliano.leporati@gmail.com Mobile: +39 331 456 58 79 Skype: drubbo LinkedIn: http://it.linkedin.com/in/drubbo