pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Fix check_exclusion_or_unique_constraint for UNIQUE NULLS NOT DI 2+ messages / 1 participants [nested] [flat]
* pgsql: Fix check_exclusion_or_unique_constraint for UNIQUE NULLS NOT DI @ 2022-08-04 18:16 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2022-08-04 18:16 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix check_exclusion_or_unique_constraint for UNIQUE NULLS NOT DISTINCT. Adjusting this function was overlooked in commit 94aa7cc5f. The only visible symptom (so far) is that INSERT ... ON CONFLICT could go into an endless loop when inserting a null that has a conflict. Richard Guo and Tom Lane, per bug #17558 from Andrew Kesper Discussion: https://postgr.es/m/17558-3f6599ffcf52fd4a@postgresql.org Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/d59383924c580a77a2346d9b1284c8589b3d43e2 Modified Files -------------- src/backend/executor/execIndexing.c | 18 ++++++++++++------ src/test/regress/expected/constraints.out | 5 +++-- src/test/regress/sql/constraints.sql | 5 +++-- 3 files changed, 18 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Fix check_exclusion_or_unique_constraint for UNIQUE NULLS NOT DI @ 2022-08-04 18:16 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2022-08-04 18:16 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix check_exclusion_or_unique_constraint for UNIQUE NULLS NOT DISTINCT. Adjusting this function was overlooked in commit 94aa7cc5f. The only visible symptom (so far) is that INSERT ... ON CONFLICT could go into an endless loop when inserting a null that has a conflict. Richard Guo and Tom Lane, per bug #17558 from Andrew Kesper Discussion: https://postgr.es/m/17558-3f6599ffcf52fd4a@postgresql.org Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/3419d51e1957855f527b94ae983fe8503aafe15c Modified Files -------------- src/backend/executor/execIndexing.c | 18 ++++++++++++------ src/test/regress/expected/constraints.out | 5 +++-- src/test/regress/sql/constraints.sql | 5 +++-- 3 files changed, 18 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-08-04 18:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-08-04 18:16 pgsql: Fix check_exclusion_or_unique_constraint for UNIQUE NULLS NOT DI Tom Lane <tgl@sss.pgh.pa.us> 2022-08-04 18:16 pgsql: Fix check_exclusion_or_unique_constraint for UNIQUE NULLS NOT DI Tom Lane <tgl@sss.pgh.pa.us>
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