Re: Can't delete role because of unknown object

[Craig Libscomb <craiglibscomb1972@xxxxxxxxx>]

On Tue, Apr 22, 2014 at 3:02 PM, droletguillaume <droletguillaume@xxxxxxxxx> wrote:

hi Craig, 

I think this thread could help you:

http://stackoverflow.com/questions/5408156/how-to-drop-a-postgresql-database-if-there-are-active-connections-to-it

Sent from Samsung Mobile

As far as I can tell, there are no connections open under this role. In fact, jpate has been gone for several months

SELECT usename
FROM pg_stat_activity
GROUP BY usename;
  usename  
------------
 postgres
 log_write
 product_readonly
(3 rows)

What I am looking for is something along the lines of

SELECT object_name

FROM ????

WHERE object_owner = 'jpate';

So I can see what jpate owns.

 

-------- Original message --------

From: Craig Libscomb

Date:04-22-2014 15:47 (GMT-05:00)

To: pgsql-general@xxxxxxxxxxxxxx

Subject: Can't delete role because of unknown object

The following command:
DROP USER IF EXISTS jpate;

generates the following output:
ERROR:  role "jpate" cannot be dropped because some objects depend on it
DETAIL:  1 object in database products

It would be most helpful to know what object in the products database depends on the jpate role, but I am unable to find anything that even begins to offer a clue. What command will show me this mysterious object, please?

Thanks,
Craig