From: | Steven Hirsch <snhirsch(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Cannot drop role |
Date: | 2017-02-13 18:43:10 |
Message-ID: | alpine.DEB.2.20.1702131336020.4109@z87 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I've seen one or two mentions of this problem with no applicable solution.
I have a case where I cannot drop a role because "...5 objects depend on
it" (according to pgAdmin 3). When I connect to the database that holds
those objects (they are not named) and try to drop the role I get an error
message:
[Error Code: 0, SQL State: XX000] ERROR: could not find tuple for
default ACL 2243075
Even after trying a number of queries that are purported to list grants
and ownerships for given ids I can turn up nothing that references the
role by name.
At this point I suspect there's something corrupted in the system catalog.
How can I find the table entry (or entries) that reference that
identifier? The fact that the message is issued suggests a link somewhere
but I cannot locate it.
Many thanks!
Steve
--
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2017-02-13 18:48:50 | Re: Cannot drop role |
Previous Message | Lazaro Garcia | 2017-02-13 14:32:05 | repmgr error with automated failover |