[COMMITTERS] pgsql: Ensure commands in extension scripts see the results ofprecedin - Mailing list pgsql-committers

From Tom Lane
Subject [COMMITTERS] pgsql: Ensure commands in extension scripts see the results ofprecedin
Date
Msg-id E1d5fw1-0000Fy-Ts@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Ensure commands in extension scripts see the results of preceding DDL.

Due to a missing CommandCounterIncrement() call, parsing of a non-utility
command in an extension script would not see the effects of the immediately
preceding DDL command, unless that command's execution ends with
CommandCounterIncrement() internally ... which some do but many don't.
Report by Philippe Beaudoin, diagnosis by Julien Rouhaud.

Rather remarkably, this bug has evaded detection since extensions were
invented, so back-patch to all supported branches.

Discussion: https://postgr.es/m/2cf7941e-4e41-7714-3de8-37b1a8f74dff@free.fr

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9209e07605afe0349660447f20d83ef165cdd0ae

Modified Files
--------------
src/backend/commands/extension.c                    | 3 +++
src/test/modules/test_extensions/test_ext3--1.0.sql | 6 ++++++
2 files changed, 9 insertions(+)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: [COMMITTERS] pgsql: extstats: change output functions to emit valid JSON
Next
From: Tom Lane
Date:
Subject: [COMMITTERS] pgsql: Remove create_singleton_array(),hard-coding the case in its sol