set local statement_timeout within a stored procedure - Mailing list pgsql-general

From Abraham, Danny
Subject set local statement_timeout within a stored procedure
Date
Msg-id SA1PR02MB969875FB9A648A34E70460998E2C2@SA1PR02MB9698.namprd02.prod.outlook.com
Whole thread Raw
Responses Re: set local statement_timeout within a stored procedure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

Is there a way to integrate " set local statement_timeout" in a stored procedure?

Something like ....

create or replace procedure call_sp()
language plpgsql
as $$
begin
   set local statement_timeout = 10000;
    call sp();
end; $$



pgsql-general by date:

Previous
From: "Bandi, Venkataramana - Dell Team"
Date:
Subject: RE: Query on Postgres SQL transaction
Next
From: Johnathan Tiamoh
Date:
Subject: Postgres database encryption