Re: [HACKERS] PG 8.1 supported platforms list: IRIX is MIA

2005-11-06 Thread Gavin Sherry
On Sun, 6 Nov 2005, Tom Lane wrote: > Gavin Sherry <[EMAIL PROTECTED]> writes: > > I had a colleague test for me on his IRIX (6.5?) MIPSPRO machine. The > > following regression tests fail: > > http://treehou.se/~finn/regression.diffs > > Hm, looks like strtod() has some bizarre behavior for input

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-06 Thread Robert Creager
When grilled further on (Sun, 06 Nov 2005 18:52:40 -0500), Andrew Dunstan <[EMAIL PROTECTED]> confessed: > > Which version is first in your path, 8.0 or 8.1? If 8.0, do you get a > different result from the 8.1 binaries? > 8.0 was first. I've specified the correct full path now for the execut

Re: [HACKERS] I can't get row type from tuple (SPI)

2005-11-06 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > rettupdesc = lookup_rowtype_tupdesc(rettype,0); This is wrong --- if you don't know what typmod to use, *always* pass -1 not 0. (I suspect that rettype is RECORD and that -1 would have resulted in a NULL result.) It seems like SPI is missing a needed

Re: [HACKERS] pgInstaller 8.1 built

2005-11-06 Thread Hiroshi Saito
From: "Marc G. Fournier" > >> Hiroshi; I think we're ready for the Japanese version whenever you're > >> ready :-) > > > > Thanks! However, I have still left much work. > > I needed of several days. then, do my best. > > "several days" isn't a biggie ... that's one of the reasons why we left > s

Re: [HACKERS] [ANNOUNCE] PostgreSQL 8.1 Beta 4

2005-11-06 Thread Kenneth Marshall
Marc, I just finished a build with the 8.1beta4 for IRIX 6.5 but without the nuances. We do not really use SGI other than in special circumstances but the regression test passed all tests: configure --without-readline using IRIX cc. Ken > On Mon, Oct 24, 2005 at 11:51:26AM -0300, Marc G. Fourni

Re: [HACKERS] [ANNOUNCE] PostgreSQL 8.1 RC1

2005-11-06 Thread Kenneth Marshall
Marc, Okay, I found an OpenSSL-0.9.7 and readline library. The IRIX 6.5 IP35 also passed with the OpenSSL and readline included. This is with the IRIX cc and not gcc. Ken > On Mon, Oct 24, 2005 at 11:51:26AM -0300, Marc G. Fournier wrote: > > > > We have released a Release Candidate 1 of the up

[HACKERS] I can't get row type from tuple (SPI)

2005-11-06 Thread Pavel Stehule
Hello I execute "select anyrowfce(..)" in plpgsql via exec_run_select I need to get inner row, but I can't find good way for it retval = SPI_getbinval(estate->eval_tuptable->vals[0], estate->eval_tuptable->tupdesc,1); rettype = SPI_gettypeid(estate->eval_tuptable->tupdesc,1); rettupdesc = loo

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-06 Thread Andrew Dunstan
Which version is first in your path, 8.0 or 8.1? If 8.0, do you get a different result from the 8.1 binaries? cheers andrew Robert Creager wrote: Hey all, I was doing a test run of a live dump from 8.0.2 to 8.1.0, and 8.1.0 took a segmentation violation 1 hour into the operation. My plan

[HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-06 Thread Robert Creager
Hey all, I was doing a test run of a live dump from 8.0.2 to 8.1.0, and 8.1.0 took a segmentation violation 1 hour into the operation. My plan is to re-do the dump/restore, and if it fails again, to re-compile with debug and cassert, and try to get a core. The command line was (8.1.0 is on port

[HACKERS] broken comment justification logic in new pgindent

2005-11-06 Thread Tom Lane
I'm noticing that the latest pgindent run has frequently rejustified block comments to end in column 80 or 81, causing them to wrap in an ugly way (at least in emacs). I thought the agreement was to limit lines to 79 chars max? For one example see lines 475 ff in /src/backend/access/nbtree/nbtpag

Re: [HACKERS] pgInstaller 8.1 built

2005-11-06 Thread Marc G. Fournier
On Mon, 7 Nov 2005, Hiroshi Saito wrote: Morning, pgInstaller 8.1 has been built and uploaded to ftp.postgresql.org/pub/win32. Please take a look if you can and report any glaring errors. Hiroshi; I think we're ready for the Japanese version whenever you're ready :-) Thanks! However, I have

Re: [HACKERS] PG 8.1 supported platforms list: IRIX is MIA

2005-11-06 Thread Gavin Sherry
On Fri, 4 Nov 2005, Tom Lane wrote: > The 8.1 supported-platforms list is looking pretty good, I think -- we > don't have updates for every single combination of OS and hardware, > but we have updates for every OS and at least one instance of all > supported CPU types. > > Except IRIX. There's be

Re: [HACKERS] [OT] somebody could explain this?

2005-11-06 Thread Otto Hirr
yes, MAJOR goof on my part. My brain cells were not firing quite right :( For those really interested, here are some resources: http://www.cs.wisc.edu/~cs354-1/cs354/karen.notes/reps.flpt.html http://cch.loria.fr/documentation/IEEE754/ACM/goldberg.pdf http://babbage.cs.qc.edu/courses/cs341/IEEE-754

Re: [HACKERS] pgInstaller 8.1 built

2005-11-06 Thread Dave Page
-Original Message- From: Hiroshi Saito [mailto:[EMAIL PROTECTED] Sent: Sun 11/6/2005 6:11 PM To: Dave Page Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] pgInstaller 8.1 built >> Hiroshi; I think we're ready for the Japanese version whenever you're >> ready :-) > > Thanks! Ho

Re: [HACKERS] pgInstaller 8.1 built

2005-11-06 Thread Hiroshi Saito
> Morning, > > pgInstaller 8.1 has been built and uploaded to > ftp.postgresql.org/pub/win32. Please take a look if you can and report > any glaring errors. > > Hiroshi; I think we're ready for the Japanese version whenever you're > ready :-) Thanks! However, I have still left much work. I neede

Re: [HACKERS] [PERFORM] insert performance for win32

2005-11-06 Thread Andrew Dunstan
Simon Riggs wrote: On Fri, 2005-11-04 at 13:21 -0500, Bruce Momjian wrote: David Fetter wrote: On Fri, Nov 04, 2005 at 01:01:20PM -0500, Tom Lane wrote: I'm inclined to treat this as an outright bug, not just a minor performance issue, because it implies that a sufficiently l

Re: [HACKERS] PG 8.1 supported platforms list: IRIX is MIA

2005-11-06 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > I had a colleague test for me on his IRIX (6.5?) MIPSPRO machine. The > following regression tests fail: > http://treehou.se/~finn/regression.diffs Hm, looks like strtod() has some bizarre behavior for input "infinity" on that machine (NOT just failing to

Re: [HACKERS] Reducing the overhead of NUMERIC data

2005-11-06 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Thu, 2005-11-03 at 10:32 -0500, Tom Lane wrote: >> I think we could make it go by cramming the sign and >> the high-order dscale bit into the first NumericDigit --- the >> digit itself can only be 0.. so there are a couple of bits >> to spare. > I'v

[HACKERS] pgInstaller 8.1 built

2005-11-06 Thread Dave Page
Morning, pgInstaller 8.1 has been built and uploaded to ftp.postgresql.org/pub/win32. Please take a look if you can and report any glaring errors. Hiroshi; I think we're ready for the Japanese version whenever you're ready :-) Regards, Dave. ---(end of broadcast)

Re: [HACKERS] [PERFORM] insert performance for win32

2005-11-06 Thread Simon Riggs
On Fri, 2005-11-04 at 13:21 -0500, Bruce Momjian wrote: > David Fetter wrote: > > On Fri, Nov 04, 2005 at 01:01:20PM -0500, Tom Lane wrote: > > > I'm inclined to treat this as an outright bug, not just a minor > > > performance issue, because it implies that a sufficiently long psql > > > script wo

Re: [HACKERS] Reducing the overhead of NUMERIC data

2005-11-06 Thread Simon Riggs
On Thu, 2005-11-03 at 10:32 -0500, Tom Lane wrote: > I'd feel a lot happier about this if we could keep the dynamic range > up to, say, 10^512 so that it's still true that NUMERIC can be a > universal parse-time representation. That would also make it even > more unlikely that anyone would complai