pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Prevent creation of duplicate not-null constraints for domains 2+ messages / 1 participants [nested] [flat]
* pgsql: Prevent creation of duplicate not-null constraints for domains @ 2025-07-03 09:47 Álvaro Herrera <alvherre@kurilemu.de> 0 siblings, 0 replies; 2+ messages in thread From: Álvaro Herrera @ 2025-07-03 09:47 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Prevent creation of duplicate not-null constraints for domains This was previously harmless, but now that we create pg_constraint rows for those, duplicates are not welcome anymore. Backpatch to 18. Co-authored-by: jian he <jian.universality@gmail.com> Co-authored-by: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://postgr.es/m/CACJufxFSC0mcQ82bSk58sO-WJY4P-o4N6RD2M0D=DD_u_6EzdQ@mail.gmail.com Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/8af310b331940ff5efd19402a3f8ee5521eb821a Modified Files -------------- src/backend/commands/typecmds.c | 14 +++++++++++--- src/test/regress/expected/domain.out | 5 +++++ src/test/regress/sql/domain.sql | 3 +++ 3 files changed, 19 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Prevent creation of duplicate not-null constraints for domains @ 2025-07-03 09:47 Álvaro Herrera <alvherre@kurilemu.de> 0 siblings, 0 replies; 2+ messages in thread From: Álvaro Herrera @ 2025-07-03 09:47 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Prevent creation of duplicate not-null constraints for domains This was previously harmless, but now that we create pg_constraint rows for those, duplicates are not welcome anymore. Backpatch to 18. Co-authored-by: jian he <jian.universality@gmail.com> Co-authored-by: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://postgr.es/m/CACJufxFSC0mcQ82bSk58sO-WJY4P-o4N6RD2M0D=DD_u_6EzdQ@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/647cffd2f3210818f3882a1ea40cfbe0a4ea8fd7 Modified Files -------------- src/backend/commands/typecmds.c | 14 +++++++++++--- src/test/regress/expected/domain.out | 5 +++++ src/test/regress/sql/domain.sql | 3 +++ 3 files changed, 19 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-07-03 09:47 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-07-03 09:47 pgsql: Prevent creation of duplicate not-null constraints for domains Álvaro Herrera <alvherre@kurilemu.de> 2025-07-03 09:47 pgsql: Prevent creation of duplicate not-null constraints for domains Álvaro Herrera <alvherre@kurilemu.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox