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:51:26 |
Message-ID: | 003b01c35cf3$612dddb0$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.
From | Date | Subject | |
---|---|---|---|
Next Message | Együd Csaba | 2003-08-07 14:55:55 | cannot open multi-query plan as cursor |
Previous Message | Shridhar Daithankar | 2003-08-07 14:40:25 | Re: crashing Xeon? |