BUG #1314: STATEMENT_TIMEOUT DOES NOT WORK PROPERLY
От | PostgreSQL Bugs List |
---|---|
Тема | BUG #1314: STATEMENT_TIMEOUT DOES NOT WORK PROPERLY |
Дата | |
Msg-id | 20041111224358.02A8473870C@www.postgresql.com обсуждение исходный текст |
Ответы |
Re: BUG #1314: STATEMENT_TIMEOUT DOES NOT WORK PROPERLY
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1314 Logged by: Adnan DURSUN Email address: adursun@hvkk.mil.tr PostgreSQL version: 8.0 Beta Operating system: W2K Description: STATEMENT_TIMEOUT DOES NOT WORK PROPERLY Details: Hi, i use PostgreSQL 8 Beta4.I write a sf like that : ///////// CREATE OR REPLACE FUNCTION fn_test() RETURNS "varchar" AS $BODY$ DECLARE c refcursor; r record; BEGIN SET SESSION STATEMENT_TIMEOUT = 1000; OPEN C FOR SELECT * FROM T_KULLANICILAR FOR UPDATE; FETCH C INTO R; RESET STATEMENT_TIMEOUT; RETURN '1'; EXCEPTION WHEN QUERY_CANCELED THEN RAISE EXCEPTION 'UNABLE TO OBTAIN LOCK... :%'; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; ///////// 1.I RUN A THIS "SELECT * FROM T_KULLANICILAR FOR UPDATE" from another session to lock T_KULLANICILAR table rows. 2.While T_KULLANICILAR table was locked,i called sf like "SELECT FN_TEST()" from psql command prompt.But STATEMENT_TIMEOUT doesn't effect. 3.but i enter "SET SESSION STATEMENT_TIMEOUT = 1000;" command before step 2, STATEMENT_TIMEOUT affects and cancel query.
В списке pgsql-bugs по дате отправления: