Replace the pg_listener-based LISTEN/NOTIFY mechanism with an in-memory queue.

[postgresql] / src / test / regress / sql / guc.sql

diff --git a/src/test/regress/sql/guc.sql b/src/test/regress/sql/guc.sql
index a7b795af47d6660c405093b5a61d42808ee054b9..21ed86f26ba259e7258e6b69afa8f8e80e2a2442 100644 (file)
--- a/src/test/regress/sql/guc.sql
+++ b/src/test/regress/sql/guc.sql
@@ -165,7 +165,7 @@ CREATE TEMP TABLE tmp_foo (data text) ON COMMIT DELETE ROWS;
 CREATE ROLE temp_reset_user;
 SET SESSION AUTHORIZATION temp_reset_user;
 -- look changes
-SELECT relname FROM pg_listener;
+SELECT pg_listening_channels();
 SELECT name FROM pg_prepared_statements;
 SELECT name FROM pg_cursors;
 SHOW vacuum_cost_delay;
@@ -174,7 +174,7 @@ SELECT current_user = 'temp_reset_user';
 -- discard everything
 DISCARD ALL;
 -- look again
-SELECT relname FROM pg_listener;
+SELECT pg_listening_channels();
 SELECT name FROM pg_prepared_statements;
 SELECT name FROM pg_cursors;
 SHOW vacuum_cost_delay;