Postgres Pro
Downloads
Home   >   mailing lists

plpsm - plpgpsm: For declared cursor in block is used unnamed portal, - Mailing list pgsql-committers

From okbob@pgfoundry.org (User Okbob)
Subject plpsm - plpgpsm: For declared cursor in block is used unnamed portal,
Date
Msg-id 20070106210430.BE6A6216E2A@pgfoundry.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
For declared cursor in block is used unnamed portal, and for identification
isn't used name but portal pointer. It solve problem with nested block with
local cursor's declaration not unique name as outer declared cursor. Named
portals are supported still for refcursors.

Opened portal identified by portal pointer is automaticly closed when block is
finalised. We cannot solve closing portals when is exception, because rollback
to savepoint close all opened portals from nested blocks.

Modified Files:
--------------
    plpgpsm/src:
        pl_exec.c (r1.22 -> r1.23)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/pl_exec.c.diff?r1=1.22&r2=1.23)
        plpgpsm.h (r1.19 -> r1.20)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/plpgpsm.h.diff?r1=1.19&r2=1.20)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Apply fix so pow() and exp() ERANGE is used only if result is not
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add: > o Consider parsing the -c string into individual queries