Re: Issue getColumns(): Nonstandard use of \\ in a string literal

From: dv <dzenmassta(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Issue getColumns(): Nonstandard use of \\ in a string literal
Date: 2011-09-09 11:05:16
Message-ID: 1315566316640-4785925.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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 '\\'

--
Dmitry

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Issue-getColumns-Nonstandard-use-of-in-a-string-literal-tp3386298p4785925.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2011-09-09 12:26:58 9.1 driver status
Previous Message Seckin Pulatkan 2011-09-08 09:23:24 Re: Group by clause problem with postgresql jdbc 9.0-801