From 5e64ad369771b66bb3e916aade735defce6e65a1 Mon Sep 17 00:00:00 2001 From: Fujii Masao Date: Fri, 24 Dec 2021 17:39:59 +0900 Subject: postgres_fdw: Revert unstable tests for postgres_fdw.application_name. Commit 6e0cb3dec1 added the tests that check that escape sequences in postgres_fdw.application_name setting are replaced with status information expectedly. But they were unstable and caused some buildfarm members to report the failure. This commit reverts those unstable tests. --- contrib/postgres_fdw/sql/postgres_fdw.sql | 21 --------------------- 1 file changed, 21 deletions(-) (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql') diff --git a/contrib/postgres_fdw/sql/postgres_fdw.sql b/contrib/postgres_fdw/sql/postgres_fdw.sql index 105b133bbd1..beeac8af1ed 100644 --- a/contrib/postgres_fdw/sql/postgres_fdw.sql +++ b/contrib/postgres_fdw/sql/postgres_fdw.sql @@ -3452,24 +3452,3 @@ CREATE FOREIGN TABLE inv_bsz (c1 int ) -- No option is allowed to be specified at foreign data wrapper level ALTER FOREIGN DATA WRAPPER postgres_fdw OPTIONS (nonexistent 'fdw'); - --- =================================================================== --- test postgres_fdw.application_name GUC --- =================================================================== --- Close all the existing cached connections so that new connection --- will be established with new setting of postgres_fdw.application_name. -SELECT 1 FROM postgres_fdw_disconnect_all(); - --- Add some escape sequences into postgres_fdw.application_name --- so as to test that they are replaced with status information expectedly. -SET postgres_fdw.application_name TO '%a%u%d%p%%'; - -BEGIN; -SELECT 1 FROM ft6 LIMIT 1; -SELECT count(*) FROM pg_stat_activity - WHERE application_name = current_setting('application_name') || - CURRENT_USER || current_database() || pg_backend_pid() || '%'; -COMMIT; - ---Clean up -RESET postgres_fdw.application_name; -- cgit v1.2.3