On Mon, Nov 28, 2011 at 4:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Phil Sorber <phil@omniti.com> writes:
>> I am still able to reproduce the "ERROR: =A0cache lookup failed for exte=
nsion
>> 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.
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, tom lane
>
That fixes it. At least I have a workaround for current installs.
Thanks.