[HACKERS] why we need both the collector & buffer process

2002-12-24 Thread William.Jiang
hi,all hackers of postgres     when postmaster start as a service . another two processes(collector & buffer ) start their work at the same time.    I have read the code and I am wondering why we need two processes to do the work. I think one process can work as well. Are there something special yo

[HACKERS] Problem with move not returning number of rows affected [was: errorwhen using move, any suggestions?]

2002-12-24 Thread Barry Lind
Noel, I now understand why this is failing. The following code in QueryExecutor.java is having problems: if (status.startsWith("INSERT") || status.startsWith("UPDATE") || status.startsWith("DELETE") || status.startsWith("MOVE")) { update_count = Integer.parseInt(status.substring(1 + statu

Re: [HACKERS] 7.3.1 regression: geometry failed on FreeBSD

2002-12-24 Thread Tom Lane
Ian Barwick <[EMAIL PROTECTED]> writes: > Seems to be a difference between 0 and -0. Is this anything to worry about? No. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregiste

[HACKERS] proper way to convert ctime to timestamp

2002-12-24 Thread GB Clark
Hi, I'm working with a legacy version of nagios. In it's database routines it uses datetime(abstime(%lu)) to input time/date info. I've replaced those to use abstime(%lu). What would be the proper way to getting this done? I've looked through the docs, but can't seem to come up with something

Re: [HACKERS] RPMS for RedHat 6.2/7.3/8.0 ready

2002-12-24 Thread Lamar Owen
On Tuesday 24 December 2002 03:49, Sander Steffann wrote: > Yesterday I tried to help Lamar by building RedHat 6.2, 7.3 and 8.0 (with > default tcl) RPMS for the 7.3.1 release. Lamar was going to put them on > ftp.postgresql.org, but it seems that he is away for Christmas... Can > anybody else plea

[HACKERS] 7.3.1 regression: geometry failed on FreeBSD

2002-12-24 Thread Ian Barwick
Hi building on FreeBSD 4.7-RELEASE; diffs attached. Seems to be a difference between 0 and -0. Is this anything to worry about? Ian Barwick [EMAIL PROTECTED] regression.diffs.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP

[HACKERS] RPMS for RedHat 6.2/7.3/8.0 ready

2002-12-24 Thread Sander Steffann
Hi all, Yesterday I tried to help Lamar by building RedHat 6.2, 7.3 and 8.0 (with default tcl) RPMS for the 7.3.1 release. Lamar was going to put them on ftp.postgresql.org, but it seems that he is away for Christmas... Can anybody else please put them on the ftp server? The RPMS are at http://www