summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/guc.out12
-rw-r--r--src/test/regress/expected/sanity_check.out3
-rw-r--r--src/test/regress/sql/guc.sql4
3 files changed, 9 insertions, 10 deletions
diff --git a/src/test/regress/expected/guc.out b/src/test/regress/expected/guc.out
index 83cacbdd209..59c120c99a3 100644
--- a/src/test/regress/expected/guc.out
+++ b/src/test/regress/expected/guc.out
@@ -532,9 +532,9 @@ 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;
- relname
------------
+SELECT pg_listening_channels();
+ pg_listening_channels
+-----------------------
foo_event
(1 row)
@@ -571,9 +571,9 @@ SELECT current_user = 'temp_reset_user';
-- discard everything
DISCARD ALL;
-- look again
-SELECT relname FROM pg_listener;
- relname
----------
+SELECT pg_listening_channels();
+ pg_listening_channels
+-----------------------
(0 rows)
SELECT name FROM pg_prepared_statements;
diff --git a/src/test/regress/expected/sanity_check.out b/src/test/regress/expected/sanity_check.out
index 4dc59d9b5de..1d9e1100448 100644
--- a/src/test/regress/expected/sanity_check.out
+++ b/src/test/regress/expected/sanity_check.out
@@ -107,7 +107,6 @@ SELECT relname, relhasindex
pg_language | t
pg_largeobject | t
pg_largeobject_metadata | t
- pg_listener | f
pg_namespace | t
pg_opclass | t
pg_operator | t
@@ -154,7 +153,7 @@ SELECT relname, relhasindex
timetz_tbl | f
tinterval_tbl | f
varchar_tbl | f
-(143 rows)
+(142 rows)
--
-- another sanity check: every system catalog that has OIDs should have
diff --git a/src/test/regress/sql/guc.sql b/src/test/regress/sql/guc.sql
index a7b795af47d..21ed86f26ba 100644
--- 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;