[Mapserver-users] Postgis query problem

zaltand@iol.it zaltand@iol.it
Sun, 30 Nov 2003 19:25:33 +0100


Hello,
If I do a QueryByPoint on layer all works, when I do QuwryByRect I have the following error:

Warning: [MapServer Error]: msPOSTGISLayerGetShape(): Error executing POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR') from layer4 WHERE OID = 18158 -ERROR: cursor "mycursor" already exists 

The indexes on the table are ok: I created two indexes, one GIST type and one on OID. My platform is LINUX with postgres 7.4, postgis 0.8.0, mapserver 4.0.1 and php 4.3.3

Thanks in advance...

Andrea


_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users