ERROR: variable not found in subplan target lists

From: Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz>
To: PGSQL mailing list <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: variable not found in subplan target lists
Date: 2007-10-04 12:00:39
Message-ID: 4704D5E7.9020500@startnet.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Miroslav Šulc 2007-10-04 12:12:09 Re: ERROR: variable not found in subplan target lists
Previous Message Florian Pflug 2007-10-04 11:54:23 Re: Generating TRUNCATE orders