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
