[GENERAL] variable not found in subplan target list

2011-11-02 Thread Roger Niederland
Hello, I stripped down the original query to what is below. I am not saying that the query below is useful except to show an error I am getting in Postgresql 9.1.1 on both SL6.1 (64 bit) and Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I am getting is: ERROR: variable not

Re: [GENERAL] variable not found in subplan target list

2011-11-02 Thread Tom Lane
Roger Niederland ro...@niederland.com writes: I stripped enough out of the database that it is only good for a test case. Here is a public url for getting at the database backup: I've committed a fix for this:

[GENERAL] variable not found in subplan target list

2011-11-01 Thread Roger Niederland
Hello, I stripped down the original query to what is below. I am not saying that the query below is useful except to show an error I am getting in Postgresql 9.1.1 on both SL6.1 (64 bit) and Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I am getting is: ERROR: variable not

Re: [GENERAL] variable not found in subplan target list

2011-11-01 Thread Tom Lane
Roger Niederland ro...@niederland.com writes: I stripped down the original query to what is below. I am not saying that the query below is useful except to show an error I am getting in Postgresql 9.1.1 on both SL6.1 (64 bit) and Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I

Re: [GENERAL] variable not found in subplan target list

2011-11-01 Thread Roger Niederland
On 11/1/2011 3:54 PM, Roger Niederland wrote: Hello, I stripped down the original query to what is below. I am not saying that the query below is useful except to show an error I am getting in Postgresql 9.1.1 on both SL6.1 (64 bit) and Windows 2008 server 9.1.1 (32-bit and 64-bit). The

Re: [GENERAL] variable not found in subplan target list

2011-11-01 Thread Tom Lane
Roger Niederland ro...@niederland.com writes: I extracted the tables from the database which generates the error above I eliminated most of the columns such that this query still exhibits this behavior to reduce the file size. I have a zipped file from windows postgresql 9.1.1 (32-bit)

Re: [GENERAL] variable not found in subplan target list

2011-11-01 Thread Roger Niederland
On 11/1/2011 8:30 PM, Tom Lane wrote: Roger Niederlandro...@niederland.com writes: I extracted the tables from the database which generates the error above I eliminated most of the columns such that this query still exhibits this behavior to reduce the file size. I have a zipped file from