Skip site navigation (1) Skip section navigation (2)

drop role fails

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: drop role fails
Date: 2008-10-29 15:40:21
Message-ID: B0D7C0A3F35FE144A70312D086CBCA9B020CA60710@ExchMailbox2.univ.dir.wwu.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2008-10-29 15:51:44
Subject: Re: drop role fails
Previous:From: Joshua DrakeDate: 2008-10-28 20:17:12
Subject: Re: system catalog views + tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group