aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2017-01-04 12:00:00 -0500
committerPeter Eisentraut <peter_e@gmx.net>2017-01-04 08:47:18 -0500
commit579f700911794d33d95628266f8ed700f113ee16 (patch)
treed6d95d24fa3da368bc44a4307bed886c47ccfe06
parent9951741bbeb3ec37ca50e9ce3df1808c931ff6a6 (diff)
downloadpostgresql-579f700911794d33d95628266f8ed700f113ee16.tar.gz
postgresql-579f700911794d33d95628266f8ed700f113ee16.zip
Better fix for sequence access in hot standby test
The purpose of the test was to check access to the sequence relation on a hot standby, so change the test to read a different column from the sequence, instead of just reading the catalog. From: Andreas Karlsson <andreas@proxel.se>
-rw-r--r--src/test/regress/expected/hs_standby_allowed.out8
-rw-r--r--src/test/regress/sql/hs_standby_allowed.sql2
2 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/expected/hs_standby_allowed.out b/src/test/regress/expected/hs_standby_allowed.out
index 487b30e1eee..526f88f2bec 100644
--- a/src/test/regress/expected/hs_standby_allowed.out
+++ b/src/test/regress/expected/hs_standby_allowed.out
@@ -26,10 +26,10 @@ COPY hs1 TO '/tmp/copy_test';
\! cat /tmp/copy_test
1
-- Access sequence directly
-select min_value as sequence_min_value from pg_sequences where sequencename = 'hsseq';
- sequence_min_value
---------------------
- 1
+select is_called from hsseq;
+ is_called
+-----------
+ f
(1 row)
-- Transactions
diff --git a/src/test/regress/sql/hs_standby_allowed.sql b/src/test/regress/sql/hs_standby_allowed.sql
index 26fb65cb492..a33199dbbdf 100644
--- a/src/test/regress/sql/hs_standby_allowed.sql
+++ b/src/test/regress/sql/hs_standby_allowed.sql
@@ -16,7 +16,7 @@ COPY hs1 TO '/tmp/copy_test';
\! cat /tmp/copy_test
-- Access sequence directly
-select min_value as sequence_min_value from pg_sequences where sequencename = 'hsseq';
+select is_called from hsseq;
-- Transactions