Phil Sorber <phil(at)omniti(dot)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