Re: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Date
Msg-id 7360.1320347956@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe  ("Gary Kenney" <gary.kenney@xerox.com>)
List pgsql-bugs
"Gary Kenney" <gary.kenney@xerox.com> writes:
> Description:        PreparedStatement#executeUpdate gets syntax error on
> apostrophe

> The value that was assigned via PreparedStatement.setString, was "Gary's
> Document".  Note the apostrophe.  Without the apostrophe, there is no error.

Right offhand I would guess that you are using an old JDBC driver that
isn't prepared for standard_conforming_strings to be turned on.

If that isn't it, I'd suggest asking for help on the pgsql-jdbc mailing
list; I'm not sure how many of those guys read pgsql-bugs.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Gary Kenney"
Date:
Subject: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Next
From: "Greg Fausak"
Date:
Subject: BUG #6286: Table Partitioning - SQL/MED - interaction broken