Re: Issue of upgrading from 9.0.4 to 9.1.3

On Sat, Apr 14, 2012 at 6:25 AM, Zhidong She <zhidong(dot)she(at)gmail(dot)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.

http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.1
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

> On Fri, Apr 13, 2012 at 2:19 PM, Raghavendra
> <raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:
> > 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
> >
> >
>