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