]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9dfcac8) | patch
ATTACH PARTITION: Don't match a PK with a UNIQUE constraint
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 15 Apr 2024 13:07:47 +0000 (15:07 +0200)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 15 Apr 2024 13:07:47 +0000 (15:07 +0200)
commitcee8db3f680b737b64d747530b48d30828cf4790
treef45fbe7ffe98414d9e4e4b8348597f3bff73ca38tree | snapshot
parent9dfcac8e15acc3b4d4d5bc02383a56ccb07229fecommit | diff
ATTACH PARTITION: Don't match a PK with a UNIQUE constraint

When matching constraints in AttachPartitionEnsureIndexes() we weren't
testing the constraint type, which could make a UNIQUE key lacking a
not-null constraint incorrectly satisfy a primary key requirement.  Fix
this by testing that the constraint types match.  (Other possible
mismatches are verified by comparing index properties.)

Discussion: https://postgr.es/m/202402051447.wimb4xmtiiyb@alvherre.pgsql
src/backend/commands/tablecmds.c diff | blob | blame | history
src/backend/utils/cache/lsyscache.c diff | blob | blame | history
src/include/utils/lsyscache.h diff | blob | blame | history
src/test/regress/expected/constraints.out diff | blob | blame | history
src/test/regress/sql/constraints.sql diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git