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

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ian Lawrence Barwick <barwick@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2023-06-23T09:58:01Z
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



Commits

  1. Improve "user mapping not found" error message