Tom Lane napsal(a):
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>
>> Miroslav Ĺ ulc wrote:
>>
>>> I just verified that the problem is in pg 8.2.5 too.
>>>
>
>
>> Can you show us the table definitions?
>>
>
> We need a *complete* test case, ie, a SQL script to provoke the error
> starting from an empty database.
>
Here is the complete dump and the query. In my case the bug is
reproducible using it.
# SELECT Invoice.* FROM Invoice WHERE false AND InvoiceGroupId IN (SELECT
InvoiceGroup.Id FROM InvoiceGroup INNER JOIN PartnerBranch ON
InvoiceGroup.PartnerBranchId = PartnerBranch.Id WHERE
PartnerBranch.PartnerIdentificationId IN (132));
ERROR: variable not found in subplan target lists
> regards, tom lane
Miroslav