pgsql: Fix bug #5269: ResetPlanCache mustn't invalidate cached utility

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix bug #5269: ResetPlanCache mustn't invalidate cached utility
Date: 2010-01-13 16:57:03
Message-ID: 20100113165703.2C06D7541B9@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2010-01-13 23:07:09 pgsql: When loading critical system indexes into the relcache, ensure we
Previous Message Tom Lane 2010-01-13 16:56:56 pgsql: Fix bug #5269: ResetPlanCache mustn't invalidate cached utility