[postgis-users] Postgis 0.8.0 QueryByRect Problem

[strk]

shpr wrote:
> Hi,
> 
> when I do a querybyrect I receive 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 (SELECT the_geom,gid,type,name,value from edtlyr_pozzi_1 WHERE site_id = 7799) as foo WHERE gid = 40716 -ERROR: cursor "mycursor" already exists 
> More Help:
> Error with POSTGIS data variable. You specified ''.
> Standard ways of specifiying are : 
> (1) 'geometry_column from geometry_table' 
> (2) 'geometry_column from (<sub query>) as foo using unique <column name> using SRID=<srid#>' 
> 
> Make sure you put in the 'using unique <column name>' and 'using SRID=#' clauses in. 
> 
> I have just upgraded the software to:
> 
> postgis 0.8.0, Mapserver 4.0.1, Postgres 7.4
> 
> my previous platform was
> 
> postgis 0.7.5 Mapserver 4.0, Postgres 7.3
> in this platform there were no problems.
> 
> I see another question like this in the maling list but not answered. Is this a bug or something in changed in postgis 0.8.0.
> 
> I have noticed that the problem appear only when I ask more than one object in the query.
> 
> Thanks in advance.
> 
> RS
> 

I think the problem is in the postgis connector of Mapserver 4.0.1 -
It seems like it tries to open a cursor for each requested object
without closing it after use.

--strk;