Re: dropping a user in 8.2.6

First do:

DROP OWNED BY user1;
then:
drop role user1;

Igor

________________________________

From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Rex Mabry
Sent: Tuesday, July 08, 2008 12:45 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] dropping a user in 8.2.6

I am using version 8.2.6

I created a role and granted all on table "instrument" in the database.
But, when I tried to drop the role, I get the following error:

mydb=# drop role system_dba;
ERROR: role "user1" cannot be dropped because some objects depend on it
DETAIL: access to table mydb_admin.instrument

Is there a way to drop a role with some sort of "cascade" option?