On Sat, Apr 14, 2012 at 6:25 AM, Zhidong She 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
On Fri, Apr 13, 2012 at 11:39 AM, Zhidong She 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 post
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
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
inser
