projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 952db49) | patch
Disallow changing NO INHERIT status of a not-null constraint
authorAlvaro Herrera
Tue, 29 Aug 2023 17:19:24 +0000 (19:19 +0200)
committerAlvaro Herrera
Tue, 29 Aug 2023 17:19:24 +0000 (19:19 +0200)
commit9b581c53418666205938311ef86047aa3c6b741f
tree326e4a2629f5cb02052e4f9c5b889895db262b75tree
parent952db4979f9fea3fb4fd1eb07b310c85fdc2a8b9commit | diff
Disallow changing NO INHERIT status of a not-null constraint

It makes no sense to add a NO INHERIT not-null constraint to a child
table that already has one in that column inherited from its parent.
Disallow that, and add tests for the relevant cases.

Per complaint from Kyotaro Horiguchi.  I also used part of his proposed
patch.

Co-authored-by: Kyotaro Horiguchi
Co-authored-by: Álvaro Herrera
Discussion: https://postgr.es/m/20230828.161658.1184657435220765047[email protected]
src/backend/catalog/heap.c diff | blob | blame | history
src/backend/catalog/pg_constraint.c diff | blob | blame | history
src/include/catalog/pg_constraint.h diff | blob | blame | history
src/test/regress/expected/inherit.out diff | blob | blame | history
src/test/regress/sql/inherit.sql diff | blob | blame | history
This is the main PostgreSQL git repository.