Re: Can't delete role because of unknown object
| От | Craig Libscomb |
|---|---|
| Тема | Re: Can't delete role because of unknown object |
| Дата | |
| Msg-id | CAABzkTjbS0U2BEz72h-V7A4E1kgC9bRH6Sp1wY+af1TO_0XMNw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Can't delete role because of unknown object (droletguillaume <droletguillaume@gmail.com>) |
| Список | pgsql-general |
On Tue, Apr 22, 2014 at 3:02 PM, droletguillaume <droletguillaume@gmail.com> wrote:
hi Craig,I think this thread could help you: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)
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 LibscombDate:04-22-2014 15:47 (GMT-05:00)Subject: [GENERAL] Can't delete role because of unknown objectThe 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 по дате отправления: