Re: statement_timeout doesnt work within plpgsql by design? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: statement_timeout doesnt work within plpgsql by design?
Date
Msg-id 7211.1171993828@sss.pgh.pa.us
Whole thread Raw
In response to statement_timeout doesnt work within plpgsql by design?  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: statement_timeout doesnt work within plpgsql by design?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
Robert Treat <xzilla@users.sourceforge.net> writes:
> pagila=# create or replace function test() returns bool as $$ begin set 
> statement_timeout = 3000; perform pg_sleep(4) ; return true; end $$ language 
> plpgsql;
> CREATE FUNCTION

statement_timeout is measured across an entire interactive command, not
individual commands within a function; and the timeout that applies to
an interactive command is determined at its beginning.  So the above
doesn't do what you think.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: statement_timeout doesnt work within plpgsql by design?
Next
From: RPK
Date:
Subject: Re: New feature request: FlashBack Query