[sr-dev] PostgreSQL problems with Kamailio_3.0.2

[Klaus Darilion]

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
>