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 extension worked fine. Thank you very much for the help.
Regards, Shanker Sent from my iPhone > On Sep 9, 2022, at 8:10 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > shanker singh <shank...@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
