The following bug has been logged online:
Bug reference: 2654
Logged by: Meikel Bisping
Email address: email@example.com
PostgreSQL version: 8.1.3
Operating system: Windows XP
Description: comments not ignored
When running the following SQL
create temp table test1 (col1 integer);
select * from test1
--select * from test2;
-- select * from test3
with JDBC using postgresql-8.1-407.jdbc3.jar.
I get an exception message:
Die Abfrage ergab mehrere ResultSets. [SQL State=0100E]
which disappears when the ; is removed from the comment.