Phil Sorber <p...@omniti.com> writes: > I am still able to reproduce the "ERROR: cache lookup failed for extension > xxxxx" if I use an explicit 'drop extension'. I am unsure how I can > reverse the state it is now in. I assume there is some system catalog > I can edit that will fix it?
I think you have some dangling entries in pg_depend --- manually deleting any rows that reference the missing pg_extension OID should fix it. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs