diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2023-11-30 05:33:55 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2023-11-30 05:34:28 +0100 |
| commit | 7e5f5177996150bf3845562d00d41d1e1847d7e3 (patch) | |
| tree | 706b1b2a3c8b9de56d1e70d035b58234aa86bd79 /contrib/postgres_fdw/expected/postgres_fdw.out | |
| parent | 3e36e48d8efecea9f2c991c0341e567af2eb363a (diff) | |
| download | postgresql-7e5f5177996150bf3845562d00d41d1e1847d7e3.tar.gz postgresql-7e5f5177996150bf3845562d00d41d1e1847d7e3.zip | |
Improve "user mapping not found" error message
Display the name of the foreign server for which the user mapping was
not found.
Author: Ian Lawrence Barwick <barwick@gmail.com>
Reviewed-by: Laurenz Albe <laurenz.albe@cybertec.at>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Discussion: https://www.postgresql.org/message-id/flat/CAB8KJ=jFzNaeyFtLcTZNOc6fd1+F93pGVLFa-wyt31wn7VNxqQ@mail.gmail.com
Diffstat (limited to 'contrib/postgres_fdw/expected/postgres_fdw.out')
| -rw-r--r-- | contrib/postgres_fdw/expected/postgres_fdw.out | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/postgres_fdw/expected/postgres_fdw.out b/contrib/postgres_fdw/expected/postgres_fdw.out index 22cae37a1eb..0a5bdf8bcc0 100644 --- a/contrib/postgres_fdw/expected/postgres_fdw.out +++ b/contrib/postgres_fdw/expected/postgres_fdw.out @@ -2717,10 +2717,10 @@ ALTER FOREIGN TABLE ft4 OPTIONS (ADD use_remote_estimate 'true'); -- regress_view_owner_another, the view owner, though it fails as expected -- due to the lack of a user mapping for that user. EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM v4; -ERROR: user mapping not found for "regress_view_owner_another" +ERROR: user mapping not found for user "regress_view_owner_another", server "loopback" -- Likewise, but with the query under an UNION ALL EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM (SELECT * FROM v4 UNION ALL SELECT * FROM v4); -ERROR: user mapping not found for "regress_view_owner_another" +ERROR: user mapping not found for user "regress_view_owner_another", server "loopback" -- Should not get that error once a user mapping is created CREATE USER MAPPING FOR regress_view_owner_another SERVER loopback OPTIONS (password_required 'false'); EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM v4; |