Re: Issue of upgrading from 9.0.4 to 9.1.3 - Mailing list pgsql-general

From Raghavendra
Subject Re: Issue of upgrading from 9.0.4 to 9.1.3
Date
Msg-id CA+h6Ahi_BTzDcbbYcSdfANZ9dEAbaYGvi6dVL6TkP=gZs=YQoA@mail.gmail.com
Whole thread Raw
In response to Issue of upgrading from 9.0.4 to 9.1.3  (Zhidong She <zhidong.she@gmail.com>)
List pgsql-general
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



 
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Issue of upgrading from 9.0.4 to 9.1.3
Next
From: Ivan Evtuhovich
Date:
Subject: Re: Two entries with the same primary key