[Bug 252120] Akonadi fails to start with postgres backend. Possibly due to wrong escape '\\ANSWERED'

[David Blewett]

https://bugs.kde.org/show_bug.cgi?id=252120


David Blewett <david at dawninglight.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at dawninglight.net




--- Comment #2 from David Blewett <david dawninglight net>  2010-12-01 04:59:06 ---
This can be fixed by enabling the "standard_conforming_strings" option in your
postgresql.conf file.

http://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS

"If the configuration parameter standard_conforming_strings is off, then
PostgreSQL recognizes backslash escapes in both regular and escape string
constants. This is for backward compatibility with the historical behavior,
where backslash escapes were always recognized. Although
standard_conforming_strings currently defaults to off, the default will change
to on in a future release for improved standards compliance. Applications are
therefore encouraged to migrate away from using backslash escapes. If you need
to use a backslash escape to represent a special character, write the string
constant with an E to be sure it will be handled the same way in future
releases.

In addition to standard_conforming_strings, the configuration parameters
escape_string_warning and backslash_quote govern treatment of backslashes in
string constants."

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.