From:
"Andrew Dunstan" <andrew(at)dunslane(dot)net>
To:
<pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc:
<tgl(at)sss(dot)pgh(dot)pa(dot)us>, <andrew(at)dunslane(dot)net>, <pg(at)rbt(dot)ca>,<pgsql-hackers(at)postgresql(dot)org>, <chriskl(at)familyhealth(dot)com(dot)au>
Subject:
Re: [PATCHES] Escape handling in strings
Date:
2005-06-17 01:03:04
Message-ID:
1293.24.211.165.134.1118970184.squirrel@www.dunslane.net (view raw or flat )
Thread:
2005-06-16 02:29:31 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-16 02:41:35 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2005-06-16 02:54:20 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-16 02:58:50 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2005-06-16 03:12:07 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-16 03:19:46 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2005-06-16 05:32:20 from Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
2005-06-16 12:56:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-16 14:32:38 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-16 03:13:58 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-16 05:08:18 from Rod Taylor <pg(at)rbt(dot)ca>
2005-06-16 12:55:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-16 14:27:27 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-16 15:25:23 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2005-06-16 16:00:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-17 01:41:05 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-17 01:03:04 from "Andrew Dunstan" <andrew(at)dunslane(dot)net>
2005-06-17 01:53:45 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-17 03:33:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-17 04:22:41 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-17 05:09:50 from Michael Glaesemann <grzm(at)myrealbox(dot)com>
2005-06-17 07:34:46 from Greg Stark <gsstark(at)mit(dot)edu>
2005-06-17 07:42:32 from Michael Glaesemann <grzm(at)myrealbox(dot)com>
2005-06-17 12:55:21 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-18 14:07:54 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2005-06-18 14:20:07 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-17 13:42:43 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Lists:
pgsql-hackers pgsql-patches
Bruce Momjian said:
> OK, the current patch warns about two things, \' with one message, and
> any backslash in a non-E string with a different message. The \'
> message can easily be avoided in clients even in 8.0 by using '', but
> for E'', there is no way to prepare an application before upgrading to
> 8.1 because 8.0 doesn't have E''. (We can add E'' in a subrelease, but
> what percentage of users are going to upgrade to that?) This is why I
> think we need to add a GUC to allow the warning to be turned off. To
> be clear, the GUC is to control the warning, not the query behavior.
>
> We could go with the second warning only in 8.2, but that seems too
> confusing --- we should deal with the escape issue in two stages,
> rather than three.
>
So you don't agree with Tom's suggestion to implement E'' a full cycle
before removing backslash processing in standard strings? Or have I
misunderstood again?
cheers
andrew
In response to
Responses
pgsql-hackers by date
Next :From: Tim AllenDate: 2005-06-17 01:04:33Subject : Re: Autovacuum in the backendPrevious :From : Josh BerkusDate : 2005-06-17 00:31:37Subject : DTrace Probes?
pgsql-patches by date
Next :From: Bruce MomjianDate: 2005-06-17 01:41:05Subject : Re: [PATCHES] Escape handling in stringsPrevious :From : Bruce MomjianDate : 2005-06-16 17:53:59Subject : Re: fsync under win32
