[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

PS:
The Postgresql (7.4) Output error is:

WARNING:  there is already a transaction in progress
ERROR:  cursor "mycursor" already exists


----- Original Message -----
From: "Stefano Bonnin" <shpr at libero.it>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Wednesday, December 10, 2003 4:53 PM
Subject: Re: [postgis-users] Postgis 0.8.0 QueryByRect Problem


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