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
