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