[GENERAL] Issue of upgrading from 9.0.4 to 9.1.3

2012-04-13 Thread Zhidong She
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

[GENERAL] pgsql ODBC text escaping issue

2011-07-20 Thread Zhidong She
Hi all, I have a problem on text escaping. In my application, I have a table offlinemsg, which has one column id with long, and has another column msg with text. pgsql ODBC and dynamic SQL binding was used when I tried to insert data into offlinemsg. the sql is : insert into offlinemsg values(?,

[GENERAL] psql core dump

2011-06-13 Thread Zhidong She
Hi Guys, I downloaded a 9.0.4 binary from EnterpriseDB: http://www.enterprisedb.com/postgresql-904-installers-linux64 After several tires, it seems the psql client is very easy to core dump. See attached the core dump information. Is it a known psql issue? or it just related to EnterpriseDB

[GENERAL] PostgreSQL 9.0 users

2011-06-11 Thread Zhidong She
Hi all, Could you please give us some typical users that already upgraded to version 9.0? We have a debate internally on choosing 8.4 or 9.0 as our product backend database. And if you have any performance benchmark result, I will highly appreciate. Many thanks, sheldon -- Sent via