Re: [HACKERS] INSERT ON CONFLICT and partitioned tables
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndquadrant.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2017-12-01T02:27:45Z
Lists: pgsql-hackers
On 24 November 2017 at 13:45, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> wrote: >> Why? There is no caller that needs information. > > It is to be used if and when ExecInsert() calls > ExecCheckIndexConstraints() in the code path to handle ON CONFLICT DO > NOTHING that we're intending to support in some cases. Note that it will > only check conflicts for the individual leaf partitions using whatever > constraint-enforcing indexes they might have. So we should have 2 patches. One for now that does DO NOTHING and another that adds the change that depends upon Alvaro's work. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Re-allow INSERT .. ON CONFLICT DO NOTHING on partitioned tables.
- 87c37e3291cb 11.0 landed