Tom Lane wrote: > hubert depesz lubaczewski <dep...@depesz.com> writes: > > On Tue, May 10, 2011 at 06:20:23PM +0200, Martin Pitt wrote: > >> Since HISTORY does not mention this, is that an explicit decision to > >> finally deprecate the old \' syntax (which would be great, as it makes > >> this thing a lot more robust and deterministic, but it might be worth > >> mentioning it in HISTORY), or an unintended side effect? > > > release notes clearly mentions is: > > http://developer.postgresql.org/pgdocs/postgres/release-9-1.html > > - Change the default value of standard_conforming_strings to on (Robert > > Haas) > > This removes a long-standing incompatibility with the SQL standard; > > escape_string_warning has produced warnings about this usage for years. E'' > > strings are the proper way to embed escapes in strings and are unaffected by > > this change. > > Hmm ... considering that's the first thing in the release notes, I'm > surprised Martin missed it. Maybe he was looking for something > mentioning backslashes ... should we add a bit that specifically says > that backslashes are now no-ops by default?
I added the word "backslash" before escapes in the attached applied patch. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml new file mode 100644 index d70c806..7737381 *** a/doc/src/sgml/release-9.1.sgml --- b/doc/src/sgml/release-9.1.sgml *************** *** 62,68 **** standard; <link linkend="guc-escape-string-warning"><varname>escape_string_warning</></link> has produced warnings about this usage for years. <literal>E''</> ! strings are the proper way to embed escapes in strings and are unaffected by this change. </para> </listitem> --- 62,68 ---- standard; <link linkend="guc-escape-string-warning"><varname>escape_string_warning</></link> has produced warnings about this usage for years. <literal>E''</> ! strings are the proper way to embed backslash escapes in strings and are unaffected by this change. </para> </listitem>
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs