23 Jun
2010
23 Jun
'10
7:06 p.m.
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,
Do you know if the E'' syntax is supported in old versions too? (we
should still support older psql versions too)
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.