1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
-- test canceling
\c test_part0
create function rsleep(val int4) returns int4 as $$ begin perform pg_sleep(val); return 1; end; $$ language plpgsql;
\c test_part1
create function rsleep(val int4) returns int4 as $$ begin perform pg_sleep(val); return 1; end; $$ language plpgsql;
\c test_part2
create function rsleep(val int4) returns int4 as $$ begin perform pg_sleep(val); return 1; end; $$ language plpgsql;
\c test_part3
create function rsleep(val int4) returns int4 as $$ begin perform pg_sleep(val); return 1; end; $$ language plpgsql;
\c regression
create function rsleep(val int4, out res int4) returns setof int4 as $$
cluster 'testcluster';
run on all;
$$ language plproxy;
set statement_timeout = '1000';
select * from rsleep(10);
ERROR: canceling statement due to statement timeout
-- test if works later
select * from rsleep(0);
res
-----
1
1
1
1
(4 rows)
|
