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

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 (view raw or flat)
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: unknown_filename
Description: text/html (984 bytes)

Responses

pgsql-bugs by date

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

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