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

From Tom Lane
Subject Re: Changed behaviour of \'
Date
Msg-id 18205.1305045877@sss.pgh.pa.us
Whole thread Raw
In response to Re: Changed behaviour of \'  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Changed behaviour of \'
List pgsql-bugs
hubert depesz lubaczewski <depesz@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?

            regards, tom lane

pgsql-bugs by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Changed behaviour of \'
Next
From: Martin Pitt
Date:
Subject: Re: Changed behaviour of \'