Tom Lane napsal(a):
Alvaro Herrera <alvherre@commandprompt.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