Skip site navigation (1) Skip section navigation (2)

Re: statement_timeout and crosstab

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tiago D(dot) Jacobs - iMDT" <tiago(at)imdt(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: statement_timeout and crosstab
Date: 2008-05-10 03:59:45
Message-ID: 24793.1210391985@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Tiago D. Jacobs - iMDT" <tiago(at)imdt(dot)com(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Tiago D. Jacobs - iMDTDate: 2008-05-10 19:52:01
Subject: Re: statement_timeout and crosstab
Previous:From: Tiago D. Jacobs - iMDTDate: 2008-05-09 19:06:14
Subject: statement_timeout and crosstab

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group