cannot open multi-query plan as cursor

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: cannot open multi-query plan as cursor
Date: 2003-08-07 14:55:55
Message-ID: 003e01c35cf4$01bd88c0$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I try to run a function which calls this query: (RH7.1 and Cygwin;
PSQL7.3.2; Odbc; Windows (XP&ME&9x) clients)
----
select distinct productid, quantity, date, (select dir from t_changes where
id=changeid) as dir from t_stockchanges join t_prod_in_pgr using
(productid) join t_productgroups on (t_productgroups.id=productgroupid)
where productid in (select productid from t_prod_in_pgr where productgroupid
= '2') and (date between ' 2003.06.07' and '2003.08.07') and
(t_stockchanges.stockid in (1)) and (productid in (select id from t_products
where id in (select productid from t_prod_in_pgr where productgroupid in
(30,26,4,2,6,7,24,25,21,29,17,23,27,28,20,22)))) and
(t_stockchanges.changeid in (7,3)) and ((prooftype = 'INV'and proofid in
(select id from t_invoices where partnerid in
(31,7,18,21,33,8,19,27,28,9,12,32,10,24,16,13,29,26,22,20,14,23,25,17,15,11,
30))) or (prooftype = 'DSPN'and proofid in (select id from t_dispatchnotes
where partnerid in
(31,7,18,21,33,8,19,27,28,9,12,32,10,24,16,13,29,26,22,20,14,23,25,17,15,11,
30))));
---

When I copy it into the console (psql) it runs well, but from function it
sends an error:
ERROR: cannot open multi-query plan as cursor

What does it mean? Could anybody help me?

Thanks a lot,

-- Együd Csaba

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.505 / Virus Database: 302 - Release Date: 2003. 07. 30.

Browse pgsql-general by date

  From Date Subject
Next Message psql-mail 2003-08-07 15:14:18 Re: Tsearch2 custom dictionaries
Previous Message Együd Csaba 2003-08-07 14:51:26 cannot open multi-query plan as cursor