4
-- hs_standby_allowed.sql
7
select count(*) as should_be_1 from hs1;
13
select count(*) as should_be_2 from hs2;
19
select count(*) as should_be_3 from hs3;
25
COPY hs1 TO '/tmp/copy_test';
28
-- Access sequence directly
29
select min_value as sequence_min_value from hsseq;
37
select count(*) as should_be_1 from hs1;
44
begin transaction read only;
45
select count(*) as should_be_1 from hs1;
52
begin transaction isolation level serializable;
53
select count(*) as should_be_1 from hs1;
59
select count(*) as should_be_1 from hs1;
65
select count(*) as should_be_1 from hs1;
73
select count(*) as should_be_1 from hs1;
81
select count(*) as should_be_1 from hs1;
89
select count(*) as should_be_1 from hs1;
97
select count(*) as should_be_1 from hs1;
105
select count(*) as should_be_1 from hs1;
112
select count(*) as should_be_2 from hs2;
120
select count(*) as should_be_1 from hs1;
127
select count(*) as should_be_2 from hs2;
134
select count(*) as should_be_2 from hs2;
141
select count(*) as should_be_3 from hs3;
147
rollback to savepoint s;
148
select count(*) as should_be_2 from hs2;
156
-- has no effect on read only transactions, but we can still set it
157
set synchronous_commit = on;
158
show synchronous_commit;
164
reset synchronous_commit;
169
DECLARE hsc CURSOR FOR select * from hs3;
176
fetch first from hsc;
196
PREPARE hsp AS select count(*) from hs1;
197
PREPARE hsp_noexec (integer) AS insert into hs1 values ($1);
207
LOCK hs1 IN ACCESS SHARE MODE;
208
LOCK hs1 IN ROW SHARE MODE;
209
LOCK hs1 IN ROW EXCLUSIVE MODE;
212
-- should work, easier if there is no test for that...