Am 23.06.2010 12:32, schrieb Klaus Feichtinger:
I have searched in the internet and found that this escape syntax is supported
since version 8.1 (released 2005-11-08).
The postgres documentation of version 8.0 describes another syntax and
therefore I guess that it was not supported.
Conclusion:
escape syntax E'' requires postgresql version>=8.1
Debian etch (oldstable) uses 7.5.22
Debian lenny (stable) uses 8.3.11-0lenny1
So this would require that users still running Etch would need to update
postgresql too if they want to update to a newer Kamailio version. For
me that would be ok - what do others think?
regards
klaus
regards
Klaus
Am 21.06.2010 21:48, schrieb Klaus Feichtinger:
Hello Klaus,
Can you test if this solves your problem? Just grep for the SQL
queries (SELECT, UPDATE, INSERT, DELETE) and replace 'strings' with
E'strings'.
That's what I've already tested before. The prefix "E" in front of the
body string helped and therefore no warning message was generated by
postgresql.
Do you know if the E'' syntax is supported in old versions too? (we
should still support older psql versions too)
klaus
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
