[Mapserver-users] multiple query problem with postgis

Thu Jan 15 10:35:10 PST 2004

This is a multi-part message in MIME format.

--Boundary_(ID_YPY3OeH8YGNt10n5cgOIwg)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT

Hello List,

Postgis and mapserver are working OK in my application except
when I use itemnquery instead of itemquery. When I use
Itemnquery using a jbox rectangle postgis complains:

msPOSTGISLayerGetShape(): Query error. Error executing POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR') from test_vlakken WHERE OID = 106744 -ERROR: cursor "mycursor" already exists 
etc.....

I saw two other recent questions regarding this problem but there was no answer to them.
Is this a bug?

I am using mapserver 4.0 with postgis 0.8 on postgresql 7.4.1 on redhat linux 9.

Regards,

W. Blanken

--Boundary_(ID_YPY3OeH8YGNt10n5cgOIwg)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: 7BIT

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello List,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Postgis and mapserver are working OK in my 
application except</FONT></DIV>
<DIV><FONT face=Arial size=2>when I use itemnquery instead of itemquery. When I 
use</FONT></DIV>
<DIV><FONT face=Arial size=2>Itemnquery using a jbox rectangle postgis 
complains:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>msPOSTGISLayerGetShape(): Query error. Error executing POSTGIS SQL 
statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(the_geom)),'NDR') from test_vlakken WHERE OID 
= 106744 -ERROR: cursor "mycursor" already exists </DIV>
<DIV><FONT face=Arial size=2>etc.....</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I saw two other recent questions regarding this 
problem but there was no answer to them.</FONT></DIV>
<DIV><FONT face=Arial size=2>Is this a bug?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am using mapserver 4.0 with postgis 0.8 on 
postgresql 7.4.1 on redhat linux 9.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>W. Blanken</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>

--Boundary_(ID_YPY3OeH8YGNt10n5cgOIwg)--