pgsql: Fix bug #5269: ResetPlanCache mustn't invalidate cached utility - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix bug #5269: ResetPlanCache mustn't invalidate cached utility
Date
Msg-id 20100113165703.2C06D7541B9@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Fix bug #5269: ResetPlanCache mustn't invalidate cached utility statements,
especially not ROLLBACK.  ROLLBACK might need to be executed in an already
aborted transaction, when there is no safe way to revalidate the plan.  But
in general there's no point in marking utility statements invalid, since
they have no plans in the normal sense of the word; so we might as well
work a bit harder here to avoid future revalidation cycles.

Back-patch to 8.4, where the bug was introduced.

Tags:
----
REL8_4_STABLE

Modified Files:
--------------
    pgsql/src/backend/utils/cache:
        plancache.c (r1.27.2.1 -> r1.27.2.2)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/plancache.c?r1=1.27.2.1&r2=1.27.2.2)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix bug #5269: ResetPlanCache mustn't invalidate cached utility
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: When loading critical system indexes into the relcache, ensure we