Hi Tom,
Thank you very much for the info. Pg-depend did had an entry for the above object. After deleting the entry the drop
extensionworked fine. Thank you very much for the help.
Regards,
Shanker
Sent from my iPhone
> On Sep 9, 2022, at 8:10 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> shanker singh <shankers@yahoo.com> writes:
>> I am trying to delete an extension db2_fdw but getting
>> ERROR: cache lookup failed for user mapping 476444
>
> Hmm, seems like there must be a pg_depend entry claiming that that
> user mapping depends on the extension; which it shouldn't, but ...
>
> Is there a pg_depend row having objid = 476444? What's in it?
>
> regards, tom lane