Enforce pg_class.relchecks limit (32,767 or INT16_MAX) pg_class.relchecks reports the number of CHECK constraints in a table, and is stored within a smallint. It was possible to define a table that could overflow the counter when specifying more than 32k constraints (new table or adding a constraint). This would cause the table to become undroppable, as this counter should never be negative when dropping these constraints.
Author: Matthias van de Meent <[email protected]> Reviewed-by: Bertrand Drouvot <[email protected]> Reviewed-by: Jian He <[email protected]> Reviewed-by: Sivaprasad <[email protected]> Discussion: https://postgr.es/m/caeze2wjsw4qahynvkttbknp85egeirgjtlmzatotdjjkia+...@mail.gmail.com Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/4cbac6287126cfb5af46c750cf7828c0d997456c Modified Files -------------- doc/src/sgml/limits.sgml | 7 +++++++ src/backend/catalog/heap.c | 29 ++++++++++++++++++++++++----- 2 files changed, 31 insertions(+), 5 deletions(-)
