Why Gemfury? Push, build, and install  RubyGems npm packages Python packages Maven artifacts PHP packages Go Modules Debian packages RPM packages NuGet packages

Repository URL to install this package:

Details    
postgresql96-test / usr / pgsql-9.6 / lib / test / regress / sql / hs_standby_functions.sql
Size: Mime:
--
-- Hot Standby tests
--
-- hs_standby_functions.sql
--

-- should fail
select txid_current();

select length(txid_current_snapshot()::text) >= 4;

select pg_start_backup('should fail');
select pg_switch_xlog();
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());