Re: patch: improve "user mapping not found" error message

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ian Lawrence Barwick <barwick(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: patch: improve "user mapping not found" error message
Date: 2023-06-23 09:58:01
Message-ID: 441c8986f4f69c766e9dd913f057a5d2d9d71a2a.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2023-06-23 at 16:45 +0900, Ian Lawrence Barwick wrote:
> Mild corner-case annoyance while doing Random Experimental Things:
>
>     postgres=# SELECT * FROM parttest;
>     ERROR:  user mapping not found for "postgres"
>
> Okaaaay, but which server?
>
>     postgres=# \det
>            List of foreign tables
>      Schema |     Table     |   Server
>     --------+---------------+-----------
>      public | parttest_10_1 | fdw_node2
>      public | parttest_10_3 | fdw_node3
>      public | parttest_10_5 | fdw_node4
>      public | parttest_10_7 | fdw_node5
>      public | parttest_10_9 | fdw_node6
>     (5 rows)
>
> (Muffled sound of small patch hatching) aha:
>
>     postgres=# SELECT * FROM parttest;
>     ERROR:  user mapping not found for user "postgres", server "fdw_node5"

+1

Yours,
Laurenz Albe

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2023-06-23 10:16:51 Re: Assert while autovacuum was executing
Previous Message John Naylor 2023-06-23 09:54:21 Re: [PoC] Improve dead tuple storage for lazy vacuum