| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tiago D. Jacobs - iMDT | 2008-05-10 19:52:01 | Re: statement_timeout and crosstab |
| Previous Message | Tiago D. Jacobs - iMDT | 2008-05-09 19:06:14 | statement_timeout and crosstab |