query string returned when no records matched - Mailing list pgsql-novice

From LLOYD,DAN (HP-Boise,ex1)
Subject query string returned when no records matched
Date
Msg-id 345D43ADFFFF864298F9ECD6C5D574E82BADE9@xboi21.boise.itc.hp.com
Whole thread Raw
Responses Re: query string returned when no records matched  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
When using PostgreSQL 7.3.x on either Linux or HP-UX hosts, the SQL query
string is returned when the query finishes without error but finds no
matching records.  This ends up being visible in the client's web browser.

An example search would start like "SELECT DISTINCT ON (test_result_name,
entry_time) entry_time, ..." then show up in the html as plain text that is
created in the JavaServer Page (JSP).  The same thing happens when running
the query in Webmin which is not tied to anything I wrote.

What I am looking for is hopefully some PostgreSQL configuration setting to
suppress the query string being reflected back to me.  The JSP handles the
resulting empty table just fine but the string pollutes the html page.

TIA,Dan

pgsql-novice by date:

Previous
From: "Abhishek Goyal"
Date:
Subject: Postgres Database Error Codes
Next
From: Allan Berger
Date:
Subject: Locking tables