Prevent setting a column as identity if its not-null constraint is invalid We don't allow null values to appear in identity-generated columns in other ways, so we shouldn't let unvalidated not-null constraints do it either. Oversight in commit a379061a22a8.
Author: jian he <[email protected]> Backpatch-through: 18 Discussion: https://postgr.es/m/CACJufxGQM_+vZoYJMaRoZfNyV=l2jxosjv_0tlascbuljxw...@mail.gmail.com Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/d9ffc27291fda0041db4f1e9c74ab1148e4b04a8 Modified Files -------------- src/backend/commands/tablecmds.c | 25 +++++++++++++++++++++++++ src/test/regress/expected/constraints.out | 4 ++++ src/test/regress/sql/constraints.sql | 3 +++ 3 files changed, 32 insertions(+)
