| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] INSERT ON CONFLICT and partitioned tables |
| Date: | 2017-11-19 22:33:14 |
| Message-ID: | CANP8+jL0cLLgPAaoL7czMdQicoKPqBrZc8oHHT0yZN6VYgG7cg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2 August 2017 at 00:56, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> The patch's job is simple:
Patch no longer applies and has some strange behaviours.
> - Remove the check in the parser that causes an error the moment the
> ON CONFLICT clause is found.
Where is the check and test that blocks ON CONFLICT UPDATE?
My understanding was the patch was intended to only remove the error
in case of DO NOTHING.
> - Fix leaf partition ResultRelInfo initialization code so that the call
> ExecOpenIndices() specifies 'true' for speculative, so that the
> information necessary for conflict checking will be initialized in the
> leaf partition's ResultRelInfo
Why? There is no caller that needs information.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2017-11-19 22:56:29 | Re: [HACKERS] [PATCH] A hook for session start |
| Previous Message | Tom Lane | 2017-11-19 21:49:49 | Re: [HACKERS] [PATCH] A hook for session start |