ERROR: variable not found in subplan target lists

Miroslav Šulc <miroslav.sulc@xxxxxxxxxxx> · Thu, 04 Oct 2007 14:00:39 +0200

Hi,

I get this error when running this query (generated by code so it is not
ideal though still valid I guess):

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));

Running these modified queries works without problems:

SELECT Invoice.* FROM Invoice WHERE InvoiceGroupId IN (SELECT
InvoiceGroup.Id FROM InvoiceGroup INNER JOIN PartnerBranch ON
InvoiceGroup.PartnerBranchId = PartnerBranch.Id  WHERE
PartnerBranch.PartnerIdentificationId IN (132));

SELECT Invoice.* FROM Invoice WHERE false AND InvoiceGroupId IN (SELECT
InvoiceGroup.Id FROM InvoiceGroup INNER JOIN PartnerBranch ON
InvoiceGroup.PartnerBranchId = PartnerBranch.Id);

SELECT Invoice.* FROM Invoice WHERE false AND InvoiceGroupId IN (SELECT
InvoiceGroup.Id FROM InvoiceGroup INNER JOIN PartnerBranch ON
InvoiceGroup.PartnerBranchId = PartnerBranch.Id  WHERE PartnerBranch.Id
IN (132));

The weird thing is it occurs only on production server, not on any other
of pg installations. All of them are pg 8.2.4 on Gentoo Linux.

I'd appreciate any help as the problem occurs on production server and I
need to solve it ASAP.

--
Miroslav Šulc

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend