Thread: Issue of upgrading from 9.0.4 to 9.1.3
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.
On 04/12/12 11:09 PM, Zhidong She wrote:
> 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?
use E'abc\'a', this is the SQL standard for escaped strings.
or even better, use $$ quoting, like $$abc'a$$
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Apr 14, 2012 at 6:25 AM, Zhidong She <zhidong.she@gmail.com> wrote:
thanks, tuning standard_confirming_strings to off make our legacy
software smoothly upgrade to 9.1.3.
Turning to OFF should be good.
is there any bad effect if we just sets this params off and not modify
our leacy code to standard E('\sd')?
Nope. Check out the below link under heading "Basic Compatibility Issues" for your reference.
---
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
>
>