pgsql: Lock affected rowtype and dependent types on ALTER ATTRIBUTE
pgsql: Lock affected rowtype and dependent types on ALTER ATTRIBUTE
От:
Noah Misch <noah@leadboat.com>
Дата:
Lock affected rowtype and dependent types on ALTER ATTRIBUTE On ALTER TYPE ... ALTER ATTRIBUTE, acquire AccessExclusiveLock on the rowtype, and all dependent types (arrays, domains, etc. over the target type). This ensures that a concurrent backend doesn't add a dependency to the type that we would miss in our dependency checks. We were already holding the lock on the corresponding relation, and that conflicted with many operations, but not all operations that use a type also lock its relation. Note that we don't lock types (or other objects except relations) when using them in queries, so the AccessExclusiveLock doesn't prevent concurrent queries from using the type. Reviewed-by: Andres Freund Security: CVE-2026-6460 Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/3429a10d495543555f120c2548a7d10064911412 Author: Heikki Linnakangas Modified Files -------------- src/backend/commands/tablecmds.c | 9 +++++++++ src/test/isolation/expected/type-ddl-locking.out | 4 +++- src/test/isolation/specs/type-ddl-locking.spec | 1 - 3 files changed, 12 insertions(+), 2 deletions(-)