Page 1 of 1

PostgreSQL and character escaping

Posted: 31.07.2007, 10:16
by plamendp
Hi,

According to PG documentation, see this:

http://www.postgresql.org/docs/8.2/stat ... AX-STRINGS

PostgreSQL is going to stop tolerate escaping characters in literal strings. Currently I got warnings about this (nonstandard using of backslash as escaping character) and that's ok, but soon...

Anyway, are you aware about this new PG behaviour?

Plamen

Posted: 31.07.2007, 12:26
by mdaems
Hi Plamen,

I was not aware. And as there's not much PG activity in the team for the moment I suppose nobody is going to look at it soon.
I don't know if we explicitly use this way to escape strings for the PG drivers in Zeoslib. If you think you can check and test this, please do so.

Of course, this information is important for the pure zeoslib user as well.
To everybody using PG : make sure your newly written queries use the new rules of string escaping.