Re: variable not found in subplan target list

Roger Niederland <roger@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 am getting is:

> ERROR: variable not found in subplan target list

This is a pretty typical symptom of a certain class of planner bugs,
but I couldn't reproduce any such failure on the basis of what you
showed here.  Please provide a *self-contained* test case.

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

            regards, tom lane