Re: OpenJPA problems running against PG 8.1

On 03/10/11 18:14, Andrew Hastie wrote:

> 2011-09-30 14:29:41 BST ERROR:  invalid escape string
> 2011-09-30 14:29:41 BST HINT:  Escape string must be empty or one
> character.
> 2011-09-30 14:29:41 BST STATEMENT:  SELECT t0.id, t0.identificationMask,
> t0.productName FROM DBTYPE t0 WHERE (t0.identificationMask LIKE $1
> ESCAPE '\\')

That's to do with standards_confirming_strings; \ is no longer an escape
by default, so '\\' is being interpreted as literally \\ instead of an
escaped '\'. Until OpenJPA is updated to recognise this, just SET
standards_conforming_strings=off or configure it in postgresql.conf .

--
Craig Ringer