[sr-dev] PostgreSQL problems with Kamailio_3.0.2

[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

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

-- 
GMX DSL: Internet-, Telefon- und Handy-Flat ab 19,99 EUR/mtl.  
Bis zu 150 EUR Startguthaben inklusive! http://portal.gmx.net/de/go/dsl