Re: set local statement_timeout within a stored procedure

2024-03-19 Thread Tom Lane
"Abraham, Danny" writes: > Is there a way to integrate " set local statement_timeout" in a stored > procedure? Not usefully. statement_timeout bounds the time spent for a single command sent by the client. So by the time you're inside a procedure, the countdown is already running (or not) for

set local statement_timeout within a stored procedure

2024-03-19 Thread Abraham, Danny
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 = 1; call sp(); end; $$