| From: | Shanker Singh <shankers(at)yahoo(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Shanker Singh <Shanker(dot)Singh(at)aexp(dot)com> |
| Subject: | Re: ERROR: cache lookup failed for user mapping 476444 |
| Date: | 2022-09-09 16:17:53 |
| Message-ID: | 40119F35-7038-479D-B1CD-6DD1021C2D08@yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> shanker singh <shankers(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maxim Boguk | 2022-09-09 21:05:27 | Re: Missing query plan for auto_explain. |
| Previous Message | Tom Lane | 2022-09-09 15:10:45 | Re: ERROR: cache lookup failed for user mapping 476444 |