Re: standard_conforming_strings

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>

To: Marko Kreen <markokr@gmail.com>

Cc: "David E.Wheeler" <david@kineticode.com>, Robert Haas <robertmhaas@gmail.com>, Josh Berkus <josh@agliodbs.com>, Tom Lane <tgl@sss.pgh.pa.us>, Cédric Villemain <cedric.villemain.debian@gmail.com>, Alex Hunsaker <badalex@gmail.com>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2010-07-20T19:34:00Z

Lists: pgsql-hackers

On tis, 2010-07-20 at 13:31 +0300, Marko Kreen wrote:
> >  http://wiki.postgresql.org/wiki/Standard_conforming_strings
> 
> There is two sorts of support:
> 
> 1. Detect stdstr on startup and use that setting.
> 
> 2. Detect online changes to stdstr and follow them.
> 
> AFAICS psycopg does not support 2).  Should we care about that?
> 
> There are probably other drivers with partial support.

I think a driver could also just use E'' when it sees a backslash in the
string.