diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/guc.out | 12 | ||||
| -rw-r--r-- | src/test/regress/expected/sanity_check.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/guc.sql | 4 |
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; |
