Re: Changed behaviour of \' - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: Changed behaviour of \'
Date
Msg-id 20110510163702.GA23678@depesz.com
Whole thread Raw
In response to Changed behaviour of \'  (Martin Pitt <mpitt@debian.org>)
Responses Re: Changed behaviour of \'
Re: Changed behaviour of \'
List pgsql-bugs
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.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-bugs by date:

Previous
From: "Bryant, Alex"
Date:
Subject: Re: Upgrading from 1.10 to 1.12 - cannot set up server
Next
From: Tom Lane
Date:
Subject: Re: Changed behaviour of \'