statement_timeout and crosstab

From: "Tiago D(dot) Jacobs - iMDT" <tiago(at)imdt(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: statement_timeout and crosstab
Date: 2008-05-09 19:06:14
Message-ID: 4824A0A6.2090300@imdt.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

<!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>

Attachment Content-Type Size
unknown_filename text/html 984 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-05-10 03:59:45 Re: statement_timeout and crosstab
Previous Message alex 2008-05-09 18:34:55 BUG #4151: Can't connect/start database after restart