| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Fix unique INCLUDE indexes on partitioned tables |
| Date: | 2019-01-14 22:29:47 |
| Message-ID: | E1gjAjr-0007BN-Ns@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Fix unique INCLUDE indexes on partitioned tables
We were considering the INCLUDE columns as part of the key, allowing
unicity-violating rows to be inserted in different partitions.
Concurrent development conflict in eb7ed3f30634 and 8224de4f42cc.
Reported-by: Justin Pryzby
Discussion: https://postgr.es/m/20190109065109.GA4285@telsasoft.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/0ad41cf537ea5f076273fcffa4c83a184bd9910f
Modified Files
--------------
src/backend/commands/indexcmds.c | 2 +-
src/test/regress/expected/indexing.out | 3 +++
src/test/regress/sql/indexing.sql | 1 +
3 files changed, 5 insertions(+), 1 deletion(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2019-01-14 23:36:07 | pgsql: Re-add default_with_oids GUC to avoid breaking old dump files. |
| Previous Message | Heikki Linnakangas | 2019-01-14 12:52:38 | pgsql: Detach postmaster process from pg_ctl's session at server startu |