BUG #14964: statement_timeout cann't set in plpgsql - Mailing list pgsql-bugs

From digoal@126.com
Subject BUG #14964: statement_timeout cann't set in plpgsql
Date
Msg-id 20171211142926.20152.70880@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14964: statement_timeout cann't set in plpgsql
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14964
Logged by:          Zhou Digoal
Email address:      digoal@126.com
PostgreSQL version: 10.1
Operating system:   centos 7.4 x64
Description:

```
create or replace function f1(int) returns setof record as $$
declare
begin
  set local statement_timeout='1ms';
  return query select count(*) as cnt, id from a where id<$1 group by id; 
end;
$$ language plpgsql strict ;
```

but it can execute every time, which when the query run more than 1ms.


pgsql-bugs by date:

Previous
From: raghavendrajsv@gmail.com
Date:
Subject: BUG #14963: Number of wal files are keep on increasing
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #14963: Number of wal files are keep on increasing