Hello all,
In my sogo log I have tons of non-standard warking message as :
WARNING: nonstandard use of \\ in a string literal
LINE 1: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"Dr...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Then I read in SOGo FAQ that this can be ignored
http://www.sogo.nu/fr/support/faq/article/i-get-nonstandard-use-of-%5C%5C-in-a-string-literal-in-my-sogo-logs-is-this-normal.html
However, my postgres shows me "standard_conforming_strings: if off
sogo=# SHOW standard_conforming_strings;
standard_conforming_strings
-----------------------------
off
(1 row)
Then I tried,
sogo=# alter database sogo set standard_conforming_strings = 'on';
ALTER DATABASE
This turned on the starndard_conforming_strings on -
After doing this the warning message has disappeard. But I am not sure if this
is the right way of doing it. I also read similar post with googling.
http://groups.google.com/group/pgsql.interfaces.jdbc/browse_thread/thread/a1b7be3108cba71b
Anil
--
[email protected]
https://inverse.ca/sogo/lists
