Re: standard_conforming_strings - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: standard_conforming_strings
Date
Msg-id AANLkTikihORDtRKaxi9UiIUoqAqFJ4F7t2QdfGQmGMK0@mail.gmail.com
Whole thread Raw
In response to Re: standard_conforming_strings  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: standard_conforming_strings
List pgsql-hackers
On 7/20/10, Peter Eisentraut <peter_e@gmx.net> wrote:
> On sön, 2010-07-18 at 09:42 -0700, David E. Wheeler wrote:
>  > On Jul 18, 2010, at 1:35 AM, Peter Eisentraut wrote:
>  >
>  > > I think there are two ways we can do this, seeing that most appear to be
>  > > in favor of doing it in the first place:  Either we just flip the
>  > > default, make a note in the release notes, and see what happens.  Or we
>  > > spend some time now and make, say, a list of driver versions and
>  > > application versions that work with standard_conforming_strings = on,
>  > > and then decide based on that, and also make that list a public resource
>  > > for packagers etc.
>  >
>  > Do both. Turn them on, then make a list and inform driver maintainers who need to update. They've got a year,
afterall. 
>
>
> Here we go then:
>  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.

--
marko


pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: Query results differ depending on operating system (using GIN)
Next
From: Robert Haas
Date:
Subject: Re: Explicit psqlrc