[Hyperic-hq-discuss] [JIRA] Created: (HHQ-745) Need to use "escape string syntax" in pg 8.2 and higher

[John S. (JIRA) <ji...@hy...>]

Need to use "escape string syntax" in pg 8.2 and higher
-------------------------------------------------------

         Key: HHQ-745
         URL: http://jira.hyperic.com/browse/HHQ-745
     Project: Hyperic HQ
        Type: Bug

    Versions: 3.0.0, 2.6, 2.7.7    
    Reporter: John Sachs
 Assigned to: Charles Lee 


Using PostgreSQL 8.2 as backend for HQ can result in many warnings being logged in the postgres log file:

WARNING: nonstandard use of \\ in a string literal at character 37
HINT: Use the escape string syntax for backslashes, e.g., E'\\'. 
STATEMENT: UPDATE EAM_EVENT SET EVENT_OBJECT = '\\254\\355\\000\\005\\163\\162\\000\\04...

According the PostgreSQL 8.2 documentation:
Applications that wish to use backslash as escape should be modified to use escape string syntax (E'...'), because the default behavior of ordinary strings will change in a future release for SQL compatibility. This variable can be enabled to help detect applications that will break.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira