Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Anssi Kääriäinen <anssi(dot)kaariainen(at)thl(dot)fi>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Kevin Grittner <kgrittn(at)ymail(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Date: 2014-12-23 19:30:16
Message-ID: CAM3SWZT01QF9taV-4q-0370CND=LxESaHTZYU7Pz3q4hRXa_kQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 23, 2014 at 5:46 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Mon, Dec 22, 2014 at 5:04 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
>> If you're dead set on having an escape hatch, maybe we should just get
>> over it and add a way of specifying a unique index by name. As I said,
>> these under-served use cases are either exceedingly rare or entirely
>> theoretical.
>
> I'm decidedly unenthusiastic about that. People don't expect CREATE
> INDEX CONCURRENTLY + DROP INDEX CONCURRENTLY to break their DML. I
> think the solution in this case would be a gateway to problems larger
> than the one we're trying to solve.

I tend to agree. I think we should just live with the fact that not
every conceivable use case will be covered, at least initially. Then,
if an appreciable demand for even more flexibility emerges, we can
revisit this. We already have a syntax that is significantly more
flexible than the equivalent feature in any other system. Let's not
lose sight of that.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2014-12-23 19:34:46 Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Previous Message Bruce Momjian 2014-12-23 19:25:35 Commit timestamp abbreviations