Re: [GENERAL] Is this a Postgres Bug?

2012-08-05 Thread Xiong He
Seems this is not a bug. Although 32767 doesn't exceed the 2bit int range. But (32767 + 10) exceed the signed 2bit int range. If you want to add index for the sum of the 2 columns, why don't you add a new column with a larger range (int32) ? -- Original -- From:

Re: [GENERAL] oracle_fdw with oracle os authentication

2012-10-24 Thread Xiong He
Not sure. But you can always avoid the OS authentication with empty user and password to access Oracle. You can use other authentication mode to access oracle instead. -- Thanks&Regards, Xiong He -- Original -- From: "Papie

Re: [GENERAL] migrate from PostgreSQL to Oracle

2012-10-25 Thread Xiong He
You can try this one: http://code.google.com/p/hisql/ then JMyETL1.0.6 -- Thanks&Regards, Xiong He -- Original -- From: "Martin Gainty"; Date: Thu, Oct 25, 2012 10:18 PM To: "jose.soares"; "pgsql-gener

Re: [GENERAL] PostgresQL intallation error

2012-10-26 Thread Xiong He
Seems you are using Win7 or above environment. You perhaps need to run the installer in administrator mode. An alternative way is to disable UAC. -- Thanks&Regards, Xiong He -- Original -- From: "Raul Feliu"; Date: Sat, Oct 27,

Re: [GENERAL] PostgresQL intallation error

2012-10-27 Thread Xiong He
Can you copy C:\Users\Ral\AppData\Local\Temp\prerun_checks.vbs to another location and verify if it can run without any issue? Make sure Windows Script Host is installed. and ".vbs" is associated with it. -- Thanks&Regards, Xiong He -

Re: [GENERAL] Why BgWriterDelay is fixed?

2012-10-29 Thread Xiong He
You can check the code in guc.c,  search "bgwriter_delay",  &BgWriterDelayIn the global user configuration, it can change the value of BgWriterDelay.Since the BgWriterDelay declared in bgwriter.h as extern.  It can be changed in the global namespace.--Thanks&am

Re: [GENERAL] Too much clients connected to the PostgreSQL Database

2012-10-29 Thread Xiong He
his can be variable in the real environment. -- Thanks&Regards, Xiong He -- Original -- From: "rodrigo"; Date: Tue, Oct 30, 2012 09:06 AM To: "Kevin Grittner"; Cc: "pgsql-general"; Subject: Re: [GENERAL]

Re: [GENERAL] Why SyncOneBuffer does not called frequently?

2012-10-31 Thread Xiong He
es.exe!__tmainCRTStartup() Line 582 + 0x19 bytesC postgres.exe!mainCRTStartup() Line 399C This is the check point background process. -- Thanks&Regards, Xiong He -- Original -- From: ""; Date: Wed, Oct 31, 2012

Re: [GENERAL] Why SyncOneBuffer does not called frequently?

2012-10-31 Thread Xiong He
This perhaps proves that the bgwriter  doesn't need to call the SyncOneBuffer again on the same buffer.--Thanks&Regards,Xiong He-- Original --From:  "Xiong He";Date:  Thu, Nov 1, 2012 07:40 AMTo:  "高健"; "pgsql-gen

Re: [GENERAL] Why PGDLLIMPORT is needed

2012-10-31 Thread Xiong He
#endif It's only useful on Windows platform for the dll building(import, export) the API entries. -- Thanks&Regards, Xiong He -- Original -- From: ""; Date: Mon, Oct 29, 2012 02:05 PM To: "pgsql-general&quo

Re: [GENERAL] Server to run Postgresql

2012-11-03 Thread Xiong He
/source/v9.2.1/As for the stability,  it depends on the real environment.   I believe PG can run well on windows environment. --Thanks&Regards,Xiong He -- Original --From:  "Bob Pawley";Date:  Sun, Nov 4, 2012 07:08 AMTo:  "P