Re: plpgsql function, comment with single quote, braces

On Jan 20, 2012, at 8:33, Роман Литовченко <roman.lytovchenko@gmail.com> wrote:

>> Otherwise what's the problem if you just deactivate escape processing?
>
> Because it is alogical.
> I follow Postgresql documentation for writing sql code. I want to
> write comments in functions. I want to write braces in literals.
>
> Сan one of the developers answer me or register this bug?
>

Speaking without full knowledge here but...

This has nothing to do with PostgreSQL; in fact the database never even sees the original form of the query.  In order
tofacilitate portability ODBC and JDBC have internal escape sequences for certain things.  In this case you want to
bypassthat escaping and supply the raw SQL to the server and thus you need to follow the suggestion and turn off escape
processing. If you do this and the problem does not go away then there is a bug otherwise things are working logically
andas intended. 

If you still do not like the solution take it up with the JDBC specification writers; the people on this mailing list
arejust following instructions. 

David J.