From:
Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To:
Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc:
Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
Alex Hunsaker <badalex(at)gmail(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: PG 9.0 and standard_conforming_strings
Date:
2010-01-30 14:55:01
Message-ID:
4B644845.6030609@timbira.com (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
Peter Eisentraut escreveu:
> Maybe the next step should be to leave standard_conforming_strings off
> but make the warning an error.
>
It will break application in the same way as enabling the parameter. Besides
that the parameter should be renamed to escape_string_*error* to reflect the
fact that it doesn't emit an error anymore. I don't think it is a good idea.
The main problem of enabling standard_conforming_strings is that applications
and/or programming language DB APIs are not prepared to support this. I don't
see a change in DB APIs (that I know of -- Python, Perl, and PHP) to add
support for producing a string according to standard_conforming_strings parameter.
IMHO we need to encourage such languages to modify their functions so we can
produce strings according to this parameter. These change will minimize the
number of problems in applications. Of course, there will be some problems in
those applications that doesn't use the escape function of the DB API but they
could always disable this parameter. ;)
As for enabling it by default, I'm afraid we will have to wait a few cycles of
development because of those changes in DB APIs. A reasonable target is 10.0. ;)
--
Euler Taveira de Oliveira
http://www.timbira.com/
In response to
Responses
pgsql-hackers by date
Next :From: Tim BunceDate: 2010-01-30 15:49:43Subject : Add on_trusted_init and on_untrusted_init to plperl UPDATED [PATCH]Previous :From : Tim BunceDate : 2010-01-30 14:51:22Subject : Re: Package namespace and Safe init cleanup for plperl
[PATCH]
