src/test/regress/sql/hs_standby_functions.sql

--
-- 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 processes of all standby coordinator and segments, since pg_locks show cluster-wide view
select gp_segment_id, locktype, virtualxid, virtualtransaction, mode, granted
from pg_locks where virtualxid = '1/1';

-- suicide is painless
select pg_cancel_backend(pg_backend_pid());