From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | depesz(at)depesz(dot)com, Martin Pitt <mpitt(at)debian(dot)org>, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Changed behaviour of \' |
Date: | 2011-05-11 03:46:05 |
Message-ID: | 18742.1305085565@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Tom Lane wrote:
>> 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.
Actually, I had something more like this in mind ...
commit ea964a451e51a32b71d004d261874adb1e135066
Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Date: Tue May 10 23:44:33 2011 -0400
Be more explicit about the meaning of the change in standard_conforming_strings.
diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml
index 7737381..280e0bb 100644
--- a/doc/src/sgml/release-9.1.sgml
+++ b/doc/src/sgml/release-9.1.sgml
@@ -58,8 +58,9 @@
</para>
<para>
- This removes a long-standing incompatibility with the SQL
- standard; <link
+ By default, backslashes are now ordinary characters in string literals,
+ not escape characters. This change removes a long-standing
+ incompatibility with the SQL 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
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-05-11 04:17:24 | Re: BUG #6019: invalid cached plan on inherited table |
Previous Message | John R Pierce | 2011-05-11 03:40:41 | Re: BUG #5994: Can't excute DBI->connect to oracle by client site |