Re: standard_conforming_strings

On 7/20/10, Peter Eisentraut <peter_e(at)gmx(dot)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, after all.
>
>
> 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