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

pgsql: The previous fix in CVS HEAD and 8.4 for handling the case where

From: heikki(at)postgresql(dot)org (Heikki Linnakangas)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: The previous fix in CVS HEAD and 8.4 for handling the case where
Date: 2010-07-05 09:27:37
Message-ID: 20100705092737.06C6F7541D4@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
The previous fix in CVS HEAD and 8.4 for handling the case where a cursor
being used in a PL/pgSQL FOR loop is closed was inadequate, as Tom Lane
pointed out. The bug affects FOR statement variants too, because you can
close an implicitly created cursor too by guessing the "<unnamed portal X>"
name created for it.

To fix that, "pin" the portal to prevent it from being dropped while it's
being used in a PL/pgSQL FOR loop. Backpatch all the way to 7.4 which is
the oldest supported version.

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/utils/mmgr:
        portalmem.c (r1.97.2.2 -> r1.97.2.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mmgr/portalmem.c?r1=1.97.2.2&r2=1.97.2.3)
    pgsql/src/include/utils:
        portal.h (r1.71 -> r1.71.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/portal.h?r1=1.71&r2=1.71.2.1)
    pgsql/src/pl/plpgsql/src:
        pl_exec.c (r1.180.2.12 -> r1.180.2.13)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_exec.c?r1=1.180.2.12&r2=1.180.2.13)

pgsql-committers by date

Next:From: Heikki LinnakangasDate: 2010-07-05 09:27:42
Subject: pgsql: The previous fix in CVS HEAD and 8.4 for handling the case where
Previous:From: Heikki LinnakangasDate: 2010-07-05 09:27:31
Subject: pgsql: The previous fix in CVS HEAD and 8.4 for handling the case where

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