question about sql comments - Mailing list pgsql-jdbc

From Alan Stange
Subject question about sql comments
Date
Msg-id 1607505e-776d-0f44-9f8e-72c9f7ba1493@rentec.com
Whole thread Raw
Responses Re: question about sql comments  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-jdbc
Hello all,

In order to track down some bugs, we thought it would be useful to
append some comments to the sql being sent to postgresql like this:     
    select foo from bar;  -- a comment with some metadata
however, the postgresql server was not including the appended comment in
the log file.

If we instead sent    
    select foo from /* a comment with some metadata */ bar;
then the comment was included in the server log file as we had hoped.

Simply put, an appended comment appears to be stripped from the sql
query by the jdbc code.

Is this something that can be turned off or disabled? I looked for
possible options in the documentation but didn't see anything.

Thank you,

Alan



pgsql-jdbc by date:

Previous
From: Brian Ye
Date:
Subject: Are these bugs?
Next
From: Thomas Kellerer
Date:
Subject: Re: question about sql comments