Re: [SQL] cursor "" already in use

2005-09-02 Thread Michael Fuhr
On Fri, Sep 02, 2005 at 02:17:52PM +0300, Stathis Stergou wrote: > ERROR: cursor "" already in use > CONTEXT: PL/pgSQL function "bufferfeatures" line 19 at open You're trying to open a cursor that's already open. Close the cursor at the end of the loop in which you opened it, so that it gets cl

[SQL] cursor "" already in use

2005-09-02 Thread Stathis Stergou
Hi, list. I've created a stored function in plpgsql which uses some functions from postgis. CREATE OR REPLACE FUNCTION "public"."bufferfeatures" (integer [], text, text, double precision) RETURNS SETOF "public"."shapedummy" AS $body$ DECLARE source_layer_features ALIAS FOR $1; source_la