[GENERAL] Issue of upgrading from 9.0.4 to 9.1.3

2012-04-12 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 inser

Re: [GENERAL] IP range in pg_hba.conf?

2011-11-08 Thread Zhidong
Can you guys explain why it is 10.17.64.0/20? Thanks! Sent from iPad 在 Nov 8, 2011,7:42 PM,Ondrej Ivanič 写道: > Hi, > > On 8 November 2011 22:33, Chrishelring wrote: >> I want to exclude access to our postgresql db using a configuration in the >> pg_hba.conf file. I have a range of IP adress t

[GENERAL] pgsql ODBC text escaping issue

2011-07-20 Thread Zhidong She
isk is full of pg_log and postgres services down. The ODBC version we used is 07.03.0100. Is it a known issue? How to avoid the massive warning log? Thanks very much! Br, Zhidong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://ww

[GENERAL] psql core dump

2011-06-12 Thread Zhidong She
package? Many thanks. Br, Zhidong [root@ucs34 data]# /opt/PostgreSQL/9.0/bin/psql -U postgres psql (9.0.4) Type "help" for help. postgres=# \l *** glibc detected *** /opt/PostgreSQL/9.0/bin/psql: realloc(): invalid next size: 0x1df011b0 *** === Backtrace: = /lib64

[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 pgsql-gener