The following bug has been logged on the website: Bug reference: 7917 Logged by: Renjith Email address: renjith...@galfar.com PostgreSQL version: 9.1.0 Operating system: Centos Description:
I using one application alfresco with postgresql 9.1. it throws error once data is migrated from another postgresql 9.1 database. kindly suggest your solution. log details [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: SqlMapClient operation; SQL []; --- The error occurred in alfresco/ibatis/#resource.dialect#/avm-common-SqlMap.xml. --- The error occurred while applying a parameter map. --- Check the alfresco.avm.parameter_IdPatternMap. --- Check the statement (query failed). --- Cause: org.postgresql.util.PSQLException: ERROR: invalid escape string Hint: Escape string must be empty or one character.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in alfresco/ibatis/#resource.dialect#/avm-common-SqlMap.xml. --- The error occurred while applying a parameter map. --- Check the alfresco.avm.parameter_IdPatternMap. --- Check the statement (query failed). --- Cause: org.postgresql.util.PSQLException: ERROR: invalid escape string Hint: Escape string must be empty or one character. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs