On Fri, 9 Sep 2011, dv wrote:
> As of postgresql 9.1 defaulted to
> standard_conforming_strings = on
> These warnings are turned to the errors, so they cannot be ignored any more:
> 2011-09-09 14:41:06 MSD ERROR: invalid escape string
> 2011-09-09 14:41:06 MSD HINT: Escape string must be empty or one character.
> 2011-09-09 14:41:06 MSD STATEMENT: SELECT COUNT(a0.id) FROM country a0
> WHERE a0."name" LIKE '%%' ESCAPE '\\'
This certainly doesn't look like any JDBC driver generated SQL, so I'm not
sure what your specific complaint here is. It looks to me like you are
using a hardcoded and incorrect escape string. If you show the Java code
associated with this, perhaps some more concrete advice could be offered.
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2011-09-09 14:25:05|
|Subject: Re: Patch: Some more state codes|
|Previous:||From: Devrim GÜNDÜZ||Date: 2011-09-09 12:26:58|
|Subject: 9.1 driver status|