Re: ERROR: variable not found in subplan target lists

[Miroslav Šulc <miroslav.sulc@xxxxxxxxxxx>]

Tom Lane napsal(a):

Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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

Attachment: failing_subquery.sql.bz2
Description: application/bzip

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/