"Tiago D. Jacobs - iMDT" <tiago@imdt.com.br> writes:
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> </head>
> <body bgcolor="#ffffff" text="#000000">
> <blockquote><small><font face="Arial">Hi, i think that there is a bug
> with the </font></small><small><font face="Arial">crosstab function,
> the query is not stopped even with a too little value for </font></small><small><font
> face="Arial">statement_timeout, like this:</font></small><br>
> <br>
> <small><font face="Arial">set statement_timeout = 1;</font></small><br>
> <small><font face="Arial">create temp table resultset_26243
> TABLESPACE temp_space as</font></small><br>
> <small><font face="Arial">SELECT *</font></small><br>
> <small><font face="Arial">FROM crosstab(</font></small><br>
> <small><font face="Arial">'', '' );<br>
> <br>
> I implemented at application level, but i think that if is a bug, it's
> good to report you.<br>
> <br>
> Any ideas?<br>
> <br>
> regards,<br>
> tiago jacobs<br>
> <br>
> <br>
> </font></small></blockquote>
> </body>
> </html>
(1) Please do not post HTML.
(2) Your example fails instantly with
ERROR: a column definition list is required for functions returning "record"
I'm prepared to believe that there's a loop in crosstab() that fails to
check for interrupts reasonably often, but it's not obvious where. You
need to provide a complete working test case if you want the problem
investigated.
regards, tom lane