Re: ERROR: cache lookup failed for user mapping 476444

[shanker singh]

 
  
Hi TEAM,
 
I am trying to delete an extension db2_fdw but getting  
 
ERROR:  cache lookup failed for user mapping 476444
 
  
 
Is there any solution or workaround for this error. 
 
  
 
Thanks and regards,
 
Shanker
 
  
 American Express made the following annotations 



"This message and any attachments are solely for the intended recipient and may 
contain confidential or privileged information. If you are not the intended 
recipient, any disclosure, copying, use, or distribution of the information 
included in this message and any attachments is prohibited. If you have 
received this communication in error, please notify us by reply e-mail and 
immediately and permanently delete this message and any attachments. Thank 
you." 


American Express a ajouté le commentaire suivant

Ce courrier et toute pièce jointe qu'il contient sont réservés au seul 
destinataire indiqué et peuvent contenir des renseignements confidentiels et 
privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, 
duplication, utilisation ou distribution du courrier ou de toute pièce jointe 
est interdite. Si vous avez reçu cette communication par erreur, veuillez nous 
en aviser par courrier et détruire immédiatement le courrier et les pièces 
jointes. Merci.

  

Re: ERROR: cache lookup failed for user mapping 476444

[Shanker Singh]

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  wrote:
> 
> shanker singh  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