Tom Lane napsal(a): > Alvaro Herrera <[EMAIL PROTECTED]> 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
failing_subquery.sql.bz2
Description: application/bzip
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
