Re: [BUGS] BUG #5154: ERROR: cannot assign non-composite value to a row variable

2009-10-31 Thread Pavel Stehule
2009/11/1 Andrew Gierth : >> "Pavel" == Pavel Stehule writes: > >  >> As discussed on the irc. I had a problem with a utility function >  >> that was being passed a NEW row and a null for the OLD row. The >  >> error was created when it tries to store the row variable in the >  >> local variab

Re: [BUGS] BUG #5149: Can't untar the src code file

2009-10-31 Thread Craig Ringer
Robert Haas wrote: >> tar -x post*.tar >> ^C >> c-76-123-226-197:Downloads donfox1$ tar -xvf postgresql-8.4.1.tar >> tar: Unrecognized archive format: Inappropriate file type or format >> tar: Error exit delayed from previous errors. I've seen some browsers on Mac OS X "helpfully" strip the .gz e

Re: [BUGS] BUG #5154: ERROR: cannot assign non-composite value to a row variable

2009-10-31 Thread Andrew Gierth
> "Pavel" == Pavel Stehule writes: >> As discussed on the irc. I had a problem with a utility function >> that was being passed a NEW row and a null for the OLD row. The >> error was created when it tries to store the row variable in the >> local variables. RhodiumToad on the list provide

[BUGS] BUG #5157: Hash index not concurrency safe

2009-10-31 Thread Jeff Janes
The following bug has been logged online: Bug reference: 5157 Logged by: Jeff Janes Email address: jeff.ja...@gmail.com PostgreSQL version: 8.4.1 Operating system: Linux Description:Hash index not concurrency safe Details: Hash index is not concurrency safe, startin

Re: [BUGS] BUG #5156: Problem compiling postgresql-8.5alpha2

2009-10-31 Thread Tom Lane
"Pierre" writes: > /usr/local/include/readline/history.h:46: error: redefinition of `struct > _hist_entry' > /usr/local/include/readline/history.h:83: error: conflicting types for > 'add_history' > /usr/local/include/readline/readline.h:94: error: previous declaration of > 'add_history' was here >

[BUGS] BUG #5156: Problem compiling postgresql-8.5alpha2

2009-10-31 Thread Pierre
The following bug has been logged online: Bug reference: 5156 Logged by: Pierre Email address: pierre...@9online.fr PostgreSQL version: 8.5a2 Operating system: GNU/Linux Description:Problem compiling postgresql-8.5alpha2 Details: [...] make -C ../../../src/port all

Re: [BUGS] BUG #5140: initdb crashes

2009-10-31 Thread Robert Haas
On Tue, Oct 27, 2009 at 10:47 AM, Marcus Lundblad wrote: > > The following bug has been logged online: > > Bug reference:      5140 > Logged by:          Marcus Lundblad > Email address:      marcus.lundb...@mogul.com > PostgreSQL version: 8.3.8 > Operating system:   Solaris 10 > Description:    

Re: [BUGS] BUG #5150: math bug

2009-10-31 Thread Robert Haas
On Fri, Oct 30, 2009 at 11:51 PM, John R Pierce wrote: > Tom Lane wrote: >> >> There is special-purpose software out there that can compute exactly >> with rational numbers, but you aren't likely to find it embedded in any >> general-purpose tools like databases --- the use-case just isn't wide >>

Re: [BUGS] Postmaster hangs

2009-10-31 Thread Karen Pease
Sorry for the delay in responding, and thanks for your help. > You didn't actually request a backtrace (bt), so all it shows is the top > stack frame. That doesn't tell us anything except that it's busy in a > system call in the kernel. For a newly-started psql process that locks as soon as the