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

2011-11-02 Thread Tom Lane
Roger Niederland 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: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e4e60e7b6125e77f679861ebf43cc6b9f9db

[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 found

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 Niederland 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

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

2011-11-01 Thread Tom Lane
Roger Niederland 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) which is about 1.5

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 e

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

2011-11-01 Thread Tom Lane
Roger Niederland 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 am getting is:

[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 found