Postgres Pro
Downloads
Home   >   mailing lists

drop role fails - Mailing list pgsql-admin

From Marc Fromm
Subject drop role fails
Date
Msg-id B0D7C0A3F35FE144A70312D086CBCA9B020CA60710@ExchMailbox2.univ.dir.wwu.edu
Whole thread Raw
Responses Re: drop role fails  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Tree view

I need to drop a role/user but receive the message:

ERROR:  role "ken" cannot be dropped because some objects depend on it

DETAIL:  1 objects in database css

1 objects in database manuals

1 objects in database cswe2

 

I checked the databases listed and the user/role ken is not associated with any items in the database, owner is always listed as postgres.

 

 

Marc

 

pgsql-admin by date:

Previous
From: Joshua Drake
Date:
Subject: Re: system catalog views + tables
Next
From: Alvaro Herrera
Date:
Subject: Re: drop role fails