[Mapserver-users] QueryByRectangle problem (PostGIS layer, PHP/MapScript)

[Paul Ramsey]

Downgrading to PgSQL 7.3 will fix this.
Upgrading your mapserver to the CVS version (4.0 or 4.1) will also fix 
it.
It is a change in cursor behavior in PostgreSQL 7.4. (They must now be 
explicitly closed at the end of a transaction.)


On Monday, February 16, 2004, at 07:16 AM, Vojtech Honzik wrote:

> I have following problem:
> When I do a query by point, everything goes ok as well as query by
> rectangle querying only one feature.
> When querying multiple features, error
> ---
> WARNING:  there is already a transaction in progress
> ERROR:  cursor "mycursor" already exists
> --
>
> occurs.
> I have been told that this is caused by that fact that MapsCript does 
> not
> close connections after itself. The solution should be adding
> explicit "CLOSE cursor" to mappostgis.h
> but - I am running the Mapserver on windows platform and I was not 
> able to
> compile PHP MapScript module with the fix (because I don't have VC++
> compiler as suggested)
>
> I'd like to ask:
> 1. What component "downgrade" could fix this error?
>
> 2. If you would prefer patch and recompilation, is there a way to 
> produce
> php_mapscript.dll using g++?
>
> 3. Does there exist another way how to solve this multiple query 
> problem?
>
> Truly yours,
> Vojtech Honzik
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
      Paul Ramsey
      Refractions Research
      Email: pramsey at refractions.net
      Phone: (250) 885-0632