Re: [BUGS] storage sync failed on magnetic disk: Permission denied

2005-11-12 Thread Tom Lane
"Valery Bondarenko" <[EMAIL PROTECTED]> writes: > When the cluster performs a massive disk operations (like nightly > vacuuming or smth) > I offten got such error in log file: > 2005-11-12 14:52:29 LOG: could not fsync segment 0 of relation > 1663/17735/210608: Permission denied > It looked li

[BUGS] BUG #2037: user function call unexpected "input out of range"

2005-11-12 Thread Tom
The following bug has been logged online: Bug reference: 2037 Logged by: Tom Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1-beta4 Operating system: Windows XP Description:user function call unexpected "input out of range" Details: --No database needs to be

[BUGS] BUG #2038: fetch items truncated

2005-11-12 Thread wgh
The following bug has been logged online: Bug reference: 2038 Logged by: wgh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: window Description:fetch items truncated Details: I use PowerBuilder8.0, i use ODBC to connect postgers8,i was in

Re: [BUGS] BUG #2037: user function call unexpected "input out of range"

2005-11-12 Thread Tom Lane
"Tom" <[EMAIL PROTECTED]> writes: > Description:user function call unexpected "input out of range" Why does this surprise you? Floating point computation is inherently inexact, so coming out with a value fractionally greater than 1 for the acos() argument doesn't seem all that unlikely.

Re: [BUGS] BUG #2037: user function call unexpected "input out of range"

2005-11-12 Thread Michael Fuhr
On Fri, Nov 11, 2005 at 09:26:47PM +, Tom wrote: > This surfaced when calculating the distances between zip codes using > latidtudes and longitudes. When the latitudes and longitudes are the same > the distance should be zero. Number 1 gives the error. Number 2 differs by a > digit in the last

Re: [BUGS] storage sync failed on magnetic disk: Permission denied

2005-11-12 Thread Qingqing Zhou
"Tom Lane" <[EMAIL PROTECTED]> wrote >> When the cluster performs a massive disk operations (like nightly >> vacuuming or smth) >> I offten got such error in log file: >> 2005-11-12 14:52:29 LOG: could not fsync segment 0 of relation >> 1663/17735/210608: Permission denied > >> It looked like as i

Re: [BUGS] BUG #2037: user function call unexpected "input out of range"

2005-11-12 Thread Tomas Zerolo
On Fri, Nov 11, 2005 at 09:26:47PM +, Tom wrote: > > The following bug has been logged online: > > Bug reference: 2037 > Logged by: Tom > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1-beta4 > Operating system: Windows XP > Description:user function ca

Re: [BUGS] BUG #2037: user function call unexpected "input out of range"

2005-11-12 Thread Bruno Wolff III
On Fri, Nov 11, 2005 at 21:26:47 +, Tom <[EMAIL PROTECTED]> wrote: > > --Calculate distance > select acos > ( > sin($1*pi()/180)*sin($3*pi()/180) > + >

Re: [BUGS] storage sync failed on magnetic disk: Permission denied

2005-11-12 Thread Qingqing Zhou
"Valery Bondarenko" <[EMAIL PROTECTED]> wrote: > Situation first occurs on _CLEAN_ Win2k server with 8.0.0 Installed by his > installer (woops :) ). > And it continues to... > Also I got it in a realy "dirty" environment with 8.1. > > But in both cases there were no antiviruses and (AFAIK) no prod

Re: [BUGS] BUG #2038: fetch items truncated

2005-11-12 Thread Qingqing Zhou
""wgh"" <[EMAIL PROTECTED]> wrote > > I use PowerBuilder8.0, i use ODBC to connect postgers8,i was in china,i > use > chinese, it have datawindow error :fetch item error!! > Does ODBC returns any non SQL_SUCCESS information? To find it out, enable the ODBC trace log and search for it. Regards,

Re: [BUGS] ECPG: "char*" instead of "const char*" in ecpglib.h

2005-11-12 Thread Qingqing Zhou
On Wed, 9 Nov 2005, Tomasz Ostrowski wrote: > > Using "char*" as an argument type instead of "const char*" in ecpglib.h > causes that for example the following sample program, basically > copied from docmentation > http://www.postgresql.org/docs/8.1/interactive/ecpg-dynamic.html , > does not comp

Re: [BUGS] BUG #2030: Chinese character support error

2005-11-12 Thread Qingqing Zhou
""Dragon"" <[EMAIL PROTECTED]> wrote > > When I install postgresql server,I can not find the chinese charactor > GB2312 > or GBK or GB18310 , and In the pgAdmin III when I create a database, in > the > Dialog I can not select Encoding GBK or other Chinese Encoding, > "A error orccured > Error :G