From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
---|---|
To: | Zhidong She <zhidong(dot)she(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Issue of upgrading from 9.0.4 to 9.1.3 |
Date: | 2012-04-13 06:19:30 |
Message-ID: | CA+h6Ahi_BTzDcbbYcSdfANZ9dEAbaYGvi6dVL6TkP=gZs=YQoA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 13, 2012 at 11:39 AM, Zhidong She <zhidong(dot)she(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Evtuhovich | 2012-04-13 06:34:38 | Re: Two entries with the same primary key |
Previous Message | John R Pierce | 2012-04-13 06:18:42 | Re: Issue of upgrading from 9.0.4 to 9.1.3 |