On Mon, Nov 28, 2011 at 4:10 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > 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 >
That fixes it. At least I have a workaround for current installs. Thanks. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
