Horton

Ensure commands in extension scripts see the results of preceding DDL.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 9209e07605afe0349660447f20d83ef165cdd0ae
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2017-05-02T22:06:09Z
Releases: 10.0 
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

Files

PathChange+/−
src/backend/commands/extension.c modified +3 −0
src/test/modules/test_extensions/test_ext3--1.0.sql modified +6 −0

Discussion