pgsql: Install checks in executor startup to ensure that the tuples - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Install checks in executor startup to ensure that the tuples
Date
Msg-id 20080808170126.1FC82755315@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Install checks in executor startup to ensure that the tuples produced by an
INSERT or UPDATE will match the target table's current rowtype.  In pre-8.3
releases inconsistency can arise with stale cached plans, as reported by
Merlin Moncure.  (We patched the equivalent hazard on the SELECT side in Feb
2007; I'm not sure why we thought there was no risk on the insertion side.)
In 8.3 and HEAD this problem should be impossible due to plan cache
invalidation management, but it seems prudent to make the check anyway.

Back-patch as far as 8.0.  7.x versions lack ALTER COLUMN TYPE, so there
seems no way to abuse a stale plan comparably.

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/executor:
        execMain.c (r1.280.2.2 -> r1.280.2.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c?r1=1.280.2.2&r2=1.280.2.3)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Install checks in executor startup to ensure that the tuples
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Install checks in executor startup to ensure that the tuples