Opened 20 years ago

Closed 20 years ago

#706 closed defect (fixed)

closing cursor in getShape

Reported by: leonardo@… Owned by: refractions
Priority: high Milestone:
Component: PostGIS Interface Version: 4.2
Severity: trivial Keywords:
Cc: dblasby@…

Description 

Hi, 

When executing the function msPOSTGISLayerGetShape, the database program 
raises the following error:

"ERROR:  cursor "mycursor" does not exist" 

In the tests i've made,  it did not afect the execution of the proccess.
That seems to  happen because the cursor is being closed with a different name.

I think that in lines 1252 and 1271 of mappostgis.c, instead of:
	PQexec(layerinfo->conn, "CLOSE mycursor");
there should be:
	PQexec(layerinfo->conn, "CLOSE mycursor2");

Change History (4)

comment:1 by dmorissette, 20 years ago

Cc: dblasby@… mapserver-bugs@… added
Component: MapScript-PHP → PostGIS Interface
Owner: changed from mapserverbugs to refractions
Summary: closing cursor in getShape → closing cursor in getShape 
This is not a PHP MapScript bug. Moving to the PostGIS component and reassigning
to default owner.

comment:2 by dblasby@…, 20 years ago 

Fixed and commited to HEAD and 4.2.
This bug crept in when I was trying to reproduce another bug - oops.

comment:3 by dmorissette, 20 years ago 

Can you please add a note to the HISTORY.TXT about this in the 4.2 branch? We
try to list *all* changes and fixes in the 4.2 HISTORY.TXT because it's a stable
branch. In the HEAD version we list only the major changes/fixes since there are
so many minor ones happening anyway. Thanks.

(BTW should this bug be marked FIXED?)

comment:4 by dblasby@…, 20 years ago

Resolution: → fixed
Status: new → closed 
HISTORY.TXT changed
Note: See TracTickets for help on using tickets.