1 files changed, 24 insertions, 0 deletions
diff --git a/src/test/regress/sql/hs_standby_functions.sql b/src/test/regress/sql/hs_standby_functions.sql
new file mode 100644
index 0000000..b57f67f
--- /dev/null
+++ b/src/test/regress/sql/hs_standby_functions.sql
@@ -0,0 +1,24 @@
+--
+-- Hot Standby tests
+--
+-- hs_standby_functions.sql
+--
+
+-- should fail
+select pg_current_xact_id();
+
+select length(pg_current_snapshot()::text) >= 4;
+
+select pg_start_backup('should fail');
+select pg_switch_wal();
+select pg_stop_backup();
+
+-- should return no rows
+select * from pg_prepared_xacts;
+
+-- just the startup process
+select locktype, virtualxid, virtualtransaction, mode, granted
+from pg_locks where virtualxid = '1/1';
+
+-- suicide is painless
+select pg_cancel_backend(pg_backend_pid());