Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-22 Thread Simon Riggs
On Wed, 2010-07-21 at 21:20 +0200, Andres Freund wrote: > > > > > > If want I can write a patch for that as well, seems to be trivial enough. > > Updated patch attached. > hm. I dont want to push - just to ask: Is any comitter looking either > at the patch or the bug? Patch looks OK, though IMHO w

[BUGS] BUG #5567: will not install

2010-07-22 Thread Denise Kanyuh
The following bug has been logged online: Bug reference: 5567 Logged by: Denise Kanyuh Email address: kan...@us.ibm.com PostgreSQL version: 8.0.15 Operating system: AIX 7.1 Description:will not install Details: When trying to test our product which incorporates post

[BUGS] BUG #5568: will not install

2010-07-22 Thread Lowell Harris
The following bug has been logged online: Bug reference: 5568 Logged by: Lowell Harris Email address: lhar...@goldstandardit.com PostgreSQL version: 8.4.4-1 Windows Operating system: Windows XP SP3 Description:will not install Details: I keep getting an error messag

Re: [BUGS] BUG #5567: will not install

2010-07-22 Thread Alex Hunsaker
On Thu, Jul 22, 2010 at 06:13, Denise Kanyuh wrote: > PostgreSQL version: 8.0.15 [ BTW the latest version of 8.0 is 8.0.25, also note 8.0 is getting EOL'ed within the next month or so, see http://www.postgresql.org/about/news.1214 ] > When trying to test our product which incorporates postgress

Re: [BUGS] BUG #5567: will not install

2010-07-22 Thread Alex Hunsaker
On Thu, Jul 22, 2010 at 11:51, Denise Kanyuh wrote: > > Alex, > Yes -- I am aware that we are on an old release -- > > when you say - my hunch is > > they do not ship binaries for AIX (7.1). > > > what binaries are you taking about --- we use the same installer and files > on AIX 6.1 and it wor

Re: [BUGS] BUG #5567: will not install

2010-07-22 Thread Chris Browne
kan...@us.ibm.com ("Denise Kanyuh") writes: > The following bug has been logged online: > > Bug reference: 5567 > Logged by: Denise Kanyuh > Email address: kan...@us.ibm.com > PostgreSQL version: 8.0.15 > Operating system: AIX 7.1 > Description:will not install > Detail

Re: [BUGS] BUG #5568: will not install

2010-07-22 Thread Kevin Grittner
"Lowell Harris" wrote: > I keep getting an error message: > "An error occured executing the Microsoft VC++ runtime installer" > This computer has MS Visual Studion 2005 and I also went ot > Microsoft and updated the CV++ runtimes. What was the URL of the download you're installing? Exactly wh

Re: [BUGS] BUG #5567: will not install

2010-07-22 Thread Alex Hunsaker
On Thu, Jul 22, 2010 at 11:21, Chris Browne wrote: >  2.  PostgreSQL Version 8.1 was the first version where AIX became >     sufficiently supported to allow it to be tested on a regular >     basis on the PostgreSQL Build Farm. >       http://pgbuildfarm.org/cgi-bin/show_status.pl > >     There

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-22 Thread Robert Haas
On Mon, Jul 19, 2010 at 4:35 PM, Andres Freund wrote: >> Well. I got that far. But why is that something worthy of support? >> For one I have a hard time imaging a sensible use case, for another doing >> anything in that deeply nested transactions seems to gets really slow (the >> chain of transac

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-22 Thread Robert Haas
On Thu, Jul 22, 2010 at 5:01 PM, Robert Haas wrote: > On Mon, Jul 19, 2010 at 4:35 PM, Andres Freund wrote: >>> Well. I got that far. But why is that something worthy of support? >>> For one I have a hard time imaging a sensible use case, for another doing >>> anything in that deeply nested trans

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-22 Thread Andres Freund
On Thu, Jul 22, 2010 at 06:29:47PM -0400, Robert Haas wrote: > On Thu, Jul 22, 2010 at 5:01 PM, Robert Haas wrote: > > On Mon, Jul 19, 2010 at 4:35 PM, Andres Freund wrote: > >>> Well. I got that far. But why is that something worthy of support? > >>> For one I have a hard time imaging a sensible

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-22 Thread Robert Haas
On Thu, Jul 22, 2010 at 6:49 PM, Andres Freund wrote: >> Can someone provide a reproducible test case for this bug?  I wasn't >> easily able to reproduce it. > 201007191950.13856.and...@anarazel.de contains a test script. You need > to actually do a action causing an xid to get calculated > (heap_

Re: [BUGS] BUG #5567: will not install

2010-07-22 Thread Robert Haas
On Thu, Jul 22, 2010 at 2:08 PM, Alex Hunsaker wrote: > Its this bit: >>> The installation failed at step: PostGreSOL Installation. >>> For additional information, please review the log files stored in the >>> archive: /opt/IBM/tivoli/tip/logs.zip > Ive no idea what that the above is doing, it loo

[BUGS] DETAIL: Failed on request of size 8

2010-07-22 Thread vamsi krishna
Hi I am running a query on postgres and got the following error: ERROR: out of memory DETAIL: Failed on request of size 8 Can somebody help? Thanks

Re: [BUGS] DETAIL: Failed on request of size 8

2010-07-22 Thread Mark Kirkwood
On 23/07/10 14:34, vamsi krishna wrote: Hi I am running a query on postgres and got the following error: ERROR: out of memory DETAIL: Failed on request of size 8 Hmm - looks like your system needs more memory to complete the query (ahem - would help to see the query, plus EXPLAIN outp

Re: [BUGS] Data extraction via sql from postgres 8.2 to oracle9i.

2010-07-22 Thread Robert Haas
On Wed, Jul 21, 2010 at 2:04 AM, wrote: > We look for Data extraction via sql from postgres 8.2 to oracle9i. > Postgres and oracle both are remote servers of solaries > Kindly suggest steps and drivers needed to perform the task. This doesn't sound like a bug to me, so you should probably choose

Re: [BUGS] BUG #5562: icon "terrestrial globe" much too big

2010-07-22 Thread Robert Haas
On Fri, Jul 16, 2010 at 6:39 AM, Heinz Groote wrote: > > The following bug has been logged online: > > Bug reference:      5562 > Logged by:          Heinz Groote > Email address:      heinz.gro...@t-online.de > PostgreSQL version: 8.4 > Operating system:   opensuse 11.2 > Description:        icon

[BUGS] page corruption after moving tablespace

2010-07-22 Thread Jeff Davis
I was investigating some strange page corruption today in which the page was completely zeroed except for the LSN and TLI. I found a sequence that can cause that problem even in 9.0: (wal_level must be set to "archive" or greater) 1. Create a tablespace "t1" 2. Create a table "foo" 3. Attach to