Re: PG 9.0 and standard_conforming_strings - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: PG 9.0 and standard_conforming_strings
Date
Msg-id 4B63E005020000250002ED90@gw.wicourts.gov
Whole thread Raw
In response to PG 9.0 and standard_conforming_strings  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tom Lane  wrote:
Cédric Villemain wrote:

>> Do you mean that turning standard_conforming_string ON may lead to
>> error with pg_dump, psql or something else ?

> Maybe. We concluded in the April 2009 thread that
> standard_conforming_strings = ON had gotten little or no field
> testing,

Well, we've been using it in hundreds of databases as our standard
setting in postgresql.conf since February, 2006.  We've used pg_dump
with it many hundreds of times, and tens of millions of JDBC
transactions per day since then.  We use psql heavily, too.  Not a
single sign of problems with it.  Surely that bumps the needle above
"little or no field testing".  Certainly there are PLs and PostgreSQL
features we don't use which should be tested first, but let's not
overstate the case.
> An actual plan here might look like "let's flip it before 9.1alpha1
> so we can get some alpha testing cycles on it" ...
That sounds sane.
-Kevin




pgsql-hackers by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: PG 9.0 and standard_conforming_strings
Next
From: Simon Riggs
Date:
Subject: Re: New VACUUM FULL