[postgis-users] Postgis 0.8.0 QueryByRect Problem

[Stefano Bonnin]

I tryed to re-install mapserver 4.0 but the same error is appeared.

So I think it depends only by Postgis.

RS
----- Original Message -----
From: "strk" <strk at keybit.net>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Wednesday, December 10, 2003 3:56 PM
Subject: Re: [postgis-users] Postgis 0.8.0 QueryByRect Problem


> 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;
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>