patch: improve "user mapping not found" error message - Mailing list pgsql-hackers

From Ian Lawrence Barwick
Subject patch: improve "user mapping not found" error message
Date
Msg-id CAB8KJ=jFzNaeyFtLcTZNOc6fd1+F93pGVLFa-wyt31wn7VNxqQ@mail.gmail.com
Whole thread Raw
Responses Re: patch: improve "user mapping not found" error message
Re: patch: improve "user mapping not found" error message
List pgsql-hackers
Hi

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"

Regards

Ian Barwick

Attachment

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Infinite Interval
Next
From: Michael Paquier
Date:
Subject: Re: Deleting prepared statements from libpq.