Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't delete role because of unknown object - Mailing list pgsql-general

From Craig Libscomb
Subject Re: Can't delete role because of unknown object
Date
Msg-id CAABzkTjbS0U2BEz72h-V7A4E1kgC9bRH6Sp1wY+af1TO_0XMNw@mail.gmail.com
Whole thread Raw
In response to Re: Can't delete role because of unknown object  (droletguillaume <droletguillaume@gmail.com>)
List pgsql-general
Tree view

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

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)
Subject: [GENERAL] 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

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Can't delete role because of unknown object
Next
From: Craig Libscomb
Date:
Subject: Re: Can't delete role because of unknown object