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 .
You can use an explicitly escaped string like E'\\' to force escape interpretation, making the string independent of the standards_conforming_strings param. Yes, I know this is horrible. Pg didn't conform to the standard, and the transition is painful. (I'm not subscribed, BTW, so reply all for any followup). -- View this message in context: http://openjpa.208410.n2.nabble.com/Postgres-V9-1-issue-with-LIKE-clause-and-Escape-Strings-tp6848069p6857386.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
