Re: [BUGS] extra columns in intermediate nodes not being removed by top level of executor

2005-09-04 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Sat, Sep 03, 2005 at 04:29:25PM -0400, Allan Wang wrote: >> Extra columns seem to be on sum(plays.length), videos.path, videoid > Here's a simplified, complete test case: Thanks for the test case. The bug seems to be introduced by the code I added a

Re: [BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Tom Lane
"Garrett Heaver" <[EMAIL PROTECTED]> writes: > Just to confirm also > I dumped the database and restored to a Suse Linux 9.3 Box > Same problem occurs (different alloc request size though) > I can forward a dump of the database if required Please (unless you've already heard from Oleg or Teodor, w

Re: [BUGS] BUG #1860: Insert failed due to unique index

2005-09-04 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Viswanath Ramineni wrote: >> I have a table with a primary key on id (integer) column and a unique >> index on varchar(10) column. Insertion fails when the value of the >> unique column is substring of an existing value. For example, if I >> have a row

Re: [BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Garrett Heaver
Just to confirm also I dumped the database and restored to a Suse Linux 9.3 Box Same problem occurs (different alloc request size though) I can forward a dump of the database if required Cheers Garrett -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ga

Re: [BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Garrett Heaver
Performed full table select - worked perfectly I can give you a dump of the table if that will help Thanks Garrett -Original Message- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: 04 September 2005 17:09 To: Garrett Heaver Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] GiST in

Re: [BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Alvaro Herrera
On Sun, Sep 04, 2005 at 04:49:27PM +0100, Garrett Heaver wrote: > I have a table with circa 5.5Million rows and an int4[] column containing > about 28 elements each. > > When I try to put a CREATE INDEX name ON table USING gist(column); > I get the following : > > ERROR: invalid memory alloc re

[BUGS] GiST intarray Memory Allocation

2005-09-04 Thread Garrett Heaver
Hi All   Platform: Win32 (XP SP2) PG: 8.0.3 (default config file)   I have a table with circa 5.5Million rows and an int4[] column containing about 28 elements each.   When I try to put a CREATE INDEX name ON table USING gist(column);   I get the following :   ERROR:  invalid mem