diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2020-10-10 19:57:25 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2020-10-10 19:57:25 -0400 |
| commit | 85d08b8b721fb3b9359bca9325bc425cc95c30b1 (patch) | |
| tree | 48b0d7259e0f8dadd6205ab7659369d264b1ee86 /contrib/postgres_fdw/sql/postgres_fdw.sql | |
| parent | eeb01eb1f560d90625ac4c8ee210f29421ba4f0d (diff) | |
| download | postgresql-85d08b8b721fb3b9359bca9325bc425cc95c30b1.tar.gz postgresql-85d08b8b721fb3b9359bca9325bc425cc95c30b1.zip | |
Band-aid new postgres_fdw test case to remove error text dependency.
Buildfarm member lorikeet is still failing the test from commit
32a9c0bdf, but now it's down to the should-have-foreseen-it problem
that the error message isn't what the expected-output file expects.
Let's see if we can get stable results by printing just the SQLSTATE.
I believe we'll reliably see ERRCODE_CONNECTION_FAILURE, since
pgfdw_report_error() will report that for any libpq-originated error.
There may be a better way to do this, but I'd like to get the
buildfarm back to green before we discuss further improvements.
Discussion: https://postgr.es/m/E1kPc9v-0005L4-2l@gemulon.postgresql.org
Discussion: https://postgr.es/m/2621622.1602184554@sss.pgh.pa.us
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
| -rw-r--r-- | contrib/postgres_fdw/sql/postgres_fdw.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/contrib/postgres_fdw/sql/postgres_fdw.sql b/contrib/postgres_fdw/sql/postgres_fdw.sql index 4da1f78956e..7581c5417b9 100644 --- a/contrib/postgres_fdw/sql/postgres_fdw.sql +++ b/contrib/postgres_fdw/sql/postgres_fdw.sql @@ -2687,9 +2687,12 @@ SELECT 1 FROM ft1 LIMIT 1; -- If the query detects the broken connection when starting new remote -- subtransaction, it doesn't reestablish new connection and should fail. +-- The text of the error might vary across platforms, so don't show it. CALL terminate_backend_and_wait('fdw_retry_check'); SAVEPOINT s; +\set VERBOSITY sqlstate SELECT 1 FROM ft1 LIMIT 1; -- should fail +\set VERBOSITY default COMMIT; -- Clean up |