Re: Issue of upgrading from 9.0.4 to 9.1.3

thanks, tuning standard_confirming_strings to off make our legacy
software smoothly upgrade to 9.1.3.

is there any bad effect if we just sets this params off and not modify
our leacy code to standard E('\sd')?

On Fri, Apr 13, 2012 at 2:19 PM, Raghavendra
<raghavendra.rao@enterprisedb.com> wrote:
> On Fri, Apr 13, 2012 at 11:39 AM, Zhidong She <zhidong.she@gmail.com> wrote:
>>
>> Hi All,
>>
>> We used 9.0.4 before and recently we plan to upgrade to 9.1.3. During
>> the test, we found a issue related to escape letter as below:
>>
>> in 9.0.4, the sql is correct
>> insert into test values('abc\'a');
>>
>> but in 9.1.3, the postgresql denied the same sql, then it worked after
>> I changed it to
>> insert into test values('abc''a');
>>
>> How to configure 9.1.3 and let it also accept \ as the escpage? Could
>> someone help me out?
>>
>> thanks very much.
>>
>
>
> -bash-4.1$ ./psql
> psql (9.1.3)
> Type "help" for help.
>
> postgres=# select version();
>                                                    version
> --------------------------------------------------------------------------------------------------------------
>  PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.6
> 20110731 (Red Hat 4.4.6-3), 64-bit
> (1 row)
>
> postgres=# select E'Raghav\'s';
>  ?column?
> ----------
>  Raghav's
> (1 row)
>
> or
>
> change the parameter standard_confirming_strings to off; and retry your
> example.
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>
>
>
>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>