Обсуждение: BUG #5750: dropping objects owned by user fails

The following bug has been logged online:

Bug reference:      5750
Logged by:          Chetan
Email address:      chetan.suttraway@enterprisedb.com
PostgreSQL version: 9.0.1
Operating system:   Ubuntu 9.10
Description:        dropping objects owned by user fails
Details:

steps to reproduce:

psql (9.0.1)
Type "help" for help.

postgres=# create user t;
CREATE ROLE
postgres=# create foreign data wrapper wrap123;
CREATE FOREIGN DATA WRAPPER
postgres=# grant usage on foreign data wrapper wrap123 to t;
GRANT
postgres=# drop owned by t;
ERROR:  unexpected object class 2328
postgres=#

On 12.11.2010 15:06, Chetan wrote:
> postgres=# create user t;
> CREATE ROLE
> postgres=# create foreign data wrapper wrap123;
> CREATE FOREIGN DATA WRAPPER
> postgres=# grant usage on foreign data wrapper wrap123 to t;
> GRANT
> postgres=# drop owned by t;
> ERROR:  unexpected object class 2328
> postgres=#

Fixed. Of course, foreign data wrappers and servers don't do anything
interesting yet, but since we have them, might as well make them work
correctly.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com