Re: [HACKERS] INSERT .. ON CONFLICT DO SELECT [FOR ..]

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Marko Tiikkaja <marko(at)joh(dot)to>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] INSERT .. ON CONFLICT DO SELECT [FOR ..]
Date: 2017-11-30 04:34:39
Message-ID: CAB7nPqRAbN-V9wDWAXe10GpmJAVW7KW9vQeGkPrOPHPr7jKVzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 5, 2017 at 3:28 AM, Marko Tiikkaja <marko(at)joh(dot)to> wrote:
> On Mon, Sep 4, 2017 at 7:46 PM, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
>>
>> On Mon, Sep 4, 2017 at 10:05 AM, Marko Tiikkaja <marko(at)joh(dot)to> wrote:
>>
>> > But I'm generally against
>> > interfaces which put arbitrary restrictions on what power users can do
>> > on
>> > the basis that less experienced people might misuse the interface.
>>
>> I agree with that as a broad principle, but disagree that it applies
>> here. Or if it does, then you have yet to convince me of it. In all
>> sincerity, if you think that I just don't understand your perspective,
>> then please try to make me understand it. Would a power user actually
>> miss ON CONFLICT DO SELECT? And if that's the case, would it really be
>> something they'd remember 5 minutes later?
>
>
> I don't know, but I don't want to be limiting what people can do just
> because I can't come up with a use case.
>
> In any case, others, feel free to chime in.

The patch does not currently apply. I am noticing as well that Peter
Geoghegan has registered himself as a reviewer a couple of hours back,
so moved to next CF with waiting on author as status.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-11-30 04:34:56 Re: pl/perl extension fails on Windows
Previous Message Michael Paquier 2017-11-30 04:31:48 Re: [HACKERS] GSOC'17 project introduction: Parallel COPY execution with errors handling