pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / 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