Robert Treat <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match