From:
"Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To:
"Mark Mielke *EXTERN*" <mark(at)mark(dot)mielke(dot)cc>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>,"Josh Berkus" <josh(at)agliodbs(dot)com>,"Alex Hunsaker" <badalex(at)gmail(dot)com>,"Bruce Momjian" <bruce(at)momjian(dot)us>,"PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: PG 9.0 and standard_conforming_strings
Date:
2010-02-02 09:13:42
Message-ID:
D960CB61B694CF459DCFB4B0128514C20393813C@exadv11.host.magwien.gv.at (view raw or flat )
Thread:
2010-01-29 19:51:53 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-29 19:55:34 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-01-29 19:57:09 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-01-29 20:28:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-29 20:42:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-29 20:50:16 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-29 21:03:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-29 21:06:55 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-29 22:44:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-29 23:59:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-30 09:33:43 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-01-30 14:55:01 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
2010-01-30 16:16:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-03 17:34:43 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2010-02-03 17:39:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-03 18:02:38 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-02-03 18:36:13 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-03 18:48:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-03 19:13:43 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-02-03 21:48:57 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-02-03 22:39:35 from marcin mank <marcin(dot)mank(at)gmail(dot)com>
2010-02-03 22:57:01 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-02-04 02:16:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-04 17:12:24 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-02-04 17:28:30 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-02-03 18:20:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-03 18:37:14 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-02-03 18:37:28 from Rod Taylor <rod(dot)taylor(at)gmail(dot)com>
2010-02-03 19:33:14 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-03 18:46:33 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2010-02-03 19:15:58 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-03 19:30:15 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
2010-02-03 19:20:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-03 21:35:43 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-02-03 19:25:45 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
2010-02-03 19:34:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-03 19:41:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-03 21:22:15 from Nathan Wagner <nw(at)hydaspes(dot)if(dot)org>
2010-01-29 21:16:04 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-29 21:24:07 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-29 21:32:16 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-01-29 21:20:16 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-29 22:34:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-29 22:46:35 from Andres Freund <andres(at)anarazel(dot)de>
2010-01-29 22:47:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-30 00:31:18 from Andres Freund <andres(at)anarazel(dot)de>
2010-01-29 22:54:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-29 23:15:08 from Andres Freund <andres(at)anarazel(dot)de>
2010-01-29 23:56:03 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-30 01:08:26 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2010-01-30 02:01:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-30 02:02:45 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-30 06:25:59 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
2010-02-02 09:13:42 from "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
2010-01-30 12:19:44 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2010-01-29 20:58:55 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-29 20:45:54 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-29 20:51:15 from Bill Moran <wmoran(at)potentialtech(dot)com>
2010-01-29 20:54:24 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-01-29 21:01:37 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-29 20:50:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
Mark Mielke wrote:
> On 01/29/2010 09:01 PM, Tom Lane wrote:
> > Maybe. We concluded in the April 2009 thread that
> > standard_conforming_strings = ON had gotten little or no field testing,
> > and I don't see any strong reason to hope that it's gotten much more
> > since then.
>
> Not to contradict any justifiable investigation, but just as
> a data point:
>
> All of my installations use:
>
> backslash_quote = off # on, off, or safe_encoding
> escape_string_warning = off
> standard_conforming_strings = on
>
> I have not encountered any problems so far. I use PostgreSQL in about 10
> production applications (too tired to count them out :-) ), from psql to
> PHP to Perl to Java. I had also assumed this feature was tested and
> supported when I enabled it, as it seemed to me to be the only sensible
> implementation, and it was consistent with my interpretation of SQL. I
> had done some testing before enabling it the first time and was
> satisfied with the results.
FWIW, I also turn it on by default in my company's installations and
revert it if there are problems.
These problems are usually carelessly written third party applications.
We discovered one omission in Npgsql which was fixed quickly.
To the best of my knowledge, JDBC and Npgsql are ready for
standard_conforming_strings=on.
I am all for changing it as soon as reasonably possible.
Yours,
Laurenz Albe
In response to
pgsql-hackers by date
Next :From: Michael MeskesDate: 2010-02-02 14:15:22Subject : Re: NaN/Inf fix for ECPG Re: out-of-scope cursor errorsPrevious :From : Boszormenyi ZoltanDate : 2010-02-02 09:03:21Subject : Re: [PATCH] Provide rowcount for utility SELECTs
