Re: [BUGS] statement_timeout and crosstab

2008-05-10 Thread Tom Lane
"Tiago D. Jacobs - iMDT" <[EMAIL PROTECTED]> writes: > ( 5 ) Here's the problem (it returns without breaking by timeout): Hm, works fine here: ERROR: canceling statement due to statement timeout CONTEXT: SQL statement "SELECT i.item_name::text As row_name, to_char(if.action_date, 'mon')::text

Re: [BUGS] statement_timeout and crosstab

2008-05-10 Thread Tiago D. Jacobs - iMDT
(1) Sorry, automatic by e-mail client, disabled. (2) I`m just trying to help to make postgresql better, my problem was solved at app level with asyncronous query and controlling the timeout by itself. I believe that this is a way of rewarding the dedication and commitment of all of you. (3)

Re: [BUGS] statement_timeout and crosstab

2008-05-09 Thread Tom Lane
"Tiago D. Jacobs - iMDT" <[EMAIL PROTECTED]> writes: > > > > > > Hi, i think that there is a bug > with the crosstab function, > the query is not stopped even with a too little value for > face="Arial">statement_timeout, like this: > > set statement_timeout = 1; > create temp table r

[BUGS] statement_timeout and crosstab

2008-05-09 Thread Tiago D. Jacobs - iMDT
Hi, i think that there is a bug with the crosstab function, the query is not stopped even with a too little value for statement_timeout, like this: set statement_timeout = 1; create temp table resultset_26243 TABLESPACE temp_space as SELECT * FROM crosstab( '', '' ); I implement