4
-- hs_standby_allowed.sql
9
select count(*) as should_be_1 from hs1;
11
select count(*) as should_be_2 from hs2;
13
select count(*) as should_be_3 from hs3;
15
COPY hs1 TO '/tmp/copy_test';
18
-- Access sequence directly
19
select min_value as sequence_min_value from hsseq;
24
select count(*) as should_be_1 from hs1;
27
begin transaction read only;
28
select count(*) as should_be_1 from hs1;
31
begin transaction isolation level serializable;
32
select count(*) as should_be_1 from hs1;
33
select count(*) as should_be_1 from hs1;
34
select count(*) as should_be_1 from hs1;
38
select count(*) as should_be_1 from hs1;
42
select count(*) as should_be_1 from hs1;
46
select count(*) as should_be_1 from hs1;
50
select count(*) as should_be_1 from hs1;
54
select count(*) as should_be_1 from hs1;
56
select count(*) as should_be_2 from hs2;
60
select count(*) as should_be_1 from hs1;
62
select count(*) as should_be_2 from hs2;
64
select count(*) as should_be_2 from hs2;
66
select count(*) as should_be_3 from hs3;
67
rollback to savepoint s;
68
select count(*) as should_be_2 from hs2;
73
-- has no effect on read only transactions, but we can still set it
74
set synchronous_commit = on;
75
show synchronous_commit;
76
reset synchronous_commit;
85
DECLARE hsc CURSOR FOR select * from hs3;
98
PREPARE hsp AS select count(*) from hs1;
99
PREPARE hsp_noexec (integer) AS insert into hs1 values ($1);
108
LOCK hs1 IN ACCESS SHARE MODE;
109
LOCK hs1 IN ROW SHARE MODE;
110
LOCK hs1 IN ROW EXCLUSIVE MODE;
114
-- should work, easier if there is no test for that...