BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"

From: spam_eater(at)gmx(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"
Date: 2012-12-09 14:12:22
Message-ID: E1ThhcE-0001nJ-1v@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: 7748
Logged by: Thomas Kellerer
Email address: spam_eater(at)gmx(dot)net
PostgreSQL version: 9.2.2
Operating system: Windows XP, 32bit
Description:

Using "drop owned by someuser" in 9.2.2 fails with the error
"unrecognized object class: 1262"

This is what happens on the commandline. The PostgreSQL cluster was
initialized right before running these steps using the command:

initdb -D pgdata --lc-messages=English -U postgres -E UTF8 -A md5

This is what happens when using "drop owned by":

c:\etc\postgres-9.2>psql
psql (9.2.2)
Type "help" for help.

postgres=# create user testuser with password 'secret';
CREATE ROLE
postgres=# create database testdb owner testuser;
CREATE DATABASE
postgres=# \q

c:\etc\postgres-9.2>psql -U testuser testdb
psql (9.2.2)
Type "help" for help.

testdb=> create table foobar (id integer);
CREATE TABLE
testdb=> drop owned by testuser;
ERROR: unrecognized object class: 1262
postgres=# select version();
version
-------------------------------------------------------------
PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 32-bit
(1 row)

Dropping the objects manually works without problems.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-12-09 16:43:14 Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"
Previous Message sumit4myself 2012-12-09 05:55:40 BUG #7746: Unable to install