aboutsummaryrefslogtreecommitdiff
path: root/contrib/postgres_fdw/sql/postgres_fdw.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
-rw-r--r--contrib/postgres_fdw/sql/postgres_fdw.sql21
1 files changed, 0 insertions, 21 deletions
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;