ERROR: variable not found in subplan target lists

Поиск
Список
Период
Сортировка
От Miroslav Šulc
Тема ERROR: variable not found in subplan target lists
Дата
Msg-id 4704D5E7.9020500@startnet.cz
обсуждение исходный текст
Ответы Re: ERROR: variable not found in subplan target lists  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Florian Pflug
Дата:
Сообщение: Re: Generating TRUNCATE orders
Следующее
От: Miroslav Šulc
Дата:
Сообщение: Re: ERROR: variable not found in subplan target lists