Horton

ATPrepAddPrimaryKey: ignore non-PK constraints

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: e09d763e25dccc40695bc824ddda9abea791d66f
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2023-09-01T12:21:27Z
Releases: 17.0 
ATPrepAddPrimaryKey: ignore non-PK constraints

Because of lack of test coverage, this function added by b0e96f311985
wasn't ignoring constraint types other than primary keys, which it
should have.  Add some lines to a test for it.

Reported-by: Richard Guo <guofenglinux@gmail.com>
Discussion: https://postgr.es/m/CAMbWs48bc-k_-1fh0dZpAhp_LiR5MfEX9haystmoBboR_4czCQ@mail.gmail.com

Files

PathChange+/−
src/backend/commands/tablecmds.c modified +9 −3
src/test/regress/expected/inherit.out modified +24 −1
src/test/regress/sql/inherit.sql modified +14 −1

Discussion