pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Cannot drop role 2+ messages / 2 participants [nested] [flat]
* Cannot drop role @ 2017-02-13 18:43 Steven Hirsch <snhirsch@gmail.com> 2017-02-13 18:48 ` Re: Cannot drop role Alvaro Herrera <alvherre@2ndquadrant.com> 0 siblings, 1 reply; 2+ messages in thread From: Steven Hirsch @ 2017-02-13 18:43 UTC (permalink / raw) To: 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 -- -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Cannot drop role 2017-02-13 18:43 Cannot drop role Steven Hirsch <snhirsch@gmail.com> @ 2017-02-13 18:48 ` Alvaro Herrera <alvherre@2ndquadrant.com> 0 siblings, 0 replies; 2+ messages in thread From: Alvaro Herrera @ 2017-02-13 18:48 UTC (permalink / raw) To: Steven Hirsch <snhirsch@gmail.com>; +Cc: pgsql-admin Steven Hirsch wrote: > At this point I suspect there's something corrupted in the system catalog. Yes, clearly. > 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. Look in pg_shdepend. Probably somebody deleted rows from pg_default_acl (and who knows what else) rather than using DDL commands, which is what they should have done. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-02-13 18:48 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2017-02-13 18:43 Cannot drop role Steven Hirsch <snhirsch@gmail.com> 2017-02-13 18:48 ` Alvaro Herrera <alvherre@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox