Issue of upgrading from 9.0.4 to 9.1.3

From: Zhidong She <zhidong(dot)she(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Issue of upgrading from 9.0.4 to 9.1.3
Date: 2012-04-13 06:09:11
Message-ID: CAAhmQAexnoZ+i4SdFYHmmg6TEEfLO+MyZDQW9CM+c1KUe9eGBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-04-13 06:18:42 Re: Issue of upgrading from 9.0.4 to 9.1.3
Previous Message Raghavendra 2012-04-13 05:59:36 Re: PGBouncer help (how to get it working)