Skip site navigation (1) Skip section navigation (2)

plpsm - plpgpsm: For declared cursor in block is used unnamed portal,

From: okbob(at)pgfoundry(dot)org (User Okbob)
To: pgsql-committers(at)postgresql(dot)org
Subject: plpsm - plpgpsm: For declared cursor in block is used unnamed portal,
Date: 2007-01-06 21:04:30
Message-ID: 20070106210430.BE6A6216E2A@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-committers
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

Next:From: Bruce MomjianDate: 2007-01-06 21:58:22
Subject: pgsql: Add: > o Consider parsing the -c string into individual queries
Previous:From: Bruce MomjianDate: 2007-01-06 20:21:29
Subject: pgsql: Apply fix so pow() and exp() ERANGE is used only if result is not

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group