On Mon, Nov 28, 2011 at 4:10 PM, Tom Lane <[email protected]> wrote: > Phil Sorber <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
