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