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

Поиск
Список
Период
Сортировка
От spam_eater@gmx.net
Тема BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"
Дата
Msg-id E1ThhcE-0001nJ-1v@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7748
Logged by:          Thomas Kellerer
Email address:      spam_eater@gmx.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=3DEnglish -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=3D# create user testuser with password 'secret';
CREATE ROLE
postgres=3D# create database testdb owner testuser;
CREATE DATABASE
postgres=3D# \q

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

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

Dropping the objects manually works without problems.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #7741: Two bugs when backing up databases with default privileges defined on public schema
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"