| From: | Robert Haas <rhaas(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Allow ON CONFLICT .. DO NOTHING on a partitioned table. |
| Date: | 2017-03-27 14:39:59 |
| Message-ID: | E1csVoN-0006eX-Vp@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Allow ON CONFLICT .. DO NOTHING on a partitioned table.
ON CONFLICT .. DO UPDATE still doesn't work, for lack of a way of
enforcing uniqueness across partitions, but we can still allow this
case.
Amit Langote, per discussion with Peter Geoghegan. Additional
wordsmithing by me.
Discussion: http://postgr.es/m/CAA-aLv7Z4uygtq-Q5CvDi9Y=VZxUyEnuWjL=EwCfOof=L04hgg@mail.gmail.com
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/8355a011a0124bdf7ccbada206a967d427039553
Modified Files
--------------
doc/src/sgml/ddl.sgml | 8 ++++++--
src/backend/parser/analyze.c | 8 --------
src/test/regress/expected/insert_conflict.out | 10 ++++++++++
src/test/regress/sql/insert_conflict.sql | 10 ++++++++++
4 files changed, 26 insertions(+), 10 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-03-27 14:54:56 | pgsql: Fix improper NULL handling in list partitioning code. |
| Previous Message | Peter Eisentraut | 2017-03-27 14:37:12 | pgsql: Change default of log_directory to 'log' |