summaryrefslogtreecommitdiffstats
path: root/src/test/regress/expected/hs_standby_functions.out
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 12:19:15 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 12:19:15 +0000
commit6eb9c5a5657d1fe77b55cc261450f3538d35a94d (patch)
tree657d8194422a5daccecfd42d654b8a245ef7b4c8 /src/test/regress/expected/hs_standby_functions.out
parentInitial commit. (diff)
downloadpostgresql-13-6eb9c5a5657d1fe77b55cc261450f3538d35a94d.tar.xz
postgresql-13-6eb9c5a5657d1fe77b55cc261450f3538d35a94d.zip
Adding upstream version 13.4.upstream/13.4upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'src/test/regress/expected/hs_standby_functions.out')
-rw-r--r--src/test/regress/expected/hs_standby_functions.out40
1 files changed, 40 insertions, 0 deletions
diff --git a/src/test/regress/expected/hs_standby_functions.out b/src/test/regress/expected/hs_standby_functions.out
new file mode 100644
index 0000000..ce846b7
--- /dev/null
+++ b/src/test/regress/expected/hs_standby_functions.out
@@ -0,0 +1,40 @@
+--
+-- Hot Standby tests
+--
+-- hs_standby_functions.sql
+--
+-- should fail
+select pg_current_xact_id();
+ERROR: cannot execute pg_current_xact_id() during recovery
+select length(pg_current_snapshot()::text) >= 4;
+ ?column?
+----------
+ t
+(1 row)
+
+select pg_start_backup('should fail');
+ERROR: recovery is in progress
+HINT: WAL control functions cannot be executed during recovery.
+select pg_switch_wal();
+ERROR: recovery is in progress
+HINT: WAL control functions cannot be executed during recovery.
+select pg_stop_backup();
+ERROR: recovery is in progress
+HINT: WAL control functions cannot be executed during recovery.
+-- should return no rows
+select * from pg_prepared_xacts;
+ transaction | gid | prepared | owner | database
+-------------+-----+----------+-------+----------
+(0 rows)
+
+-- just the startup process
+select locktype, virtualxid, virtualtransaction, mode, granted
+from pg_locks where virtualxid = '1/1';
+ locktype | virtualxid | virtualtransaction | mode | granted
+------------+------------+--------------------+---------------+---------
+ virtualxid | 1/1 | 1/0 | ExclusiveLock | t
+(1 row)
+
+-- suicide is painless
+select pg_cancel_backend(pg_backend_pid());
+ERROR: canceling statement due to user request