Horton

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

Marko Tiikkaja <marko@joh.to>

View thread View on postgr.es
From: Marko Tiikkaja <marko@joh.to>
To: Peter Geoghegan <pg@bowt.ie>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2017-08-15T07:17:51Z
Lists: pgsql-hackers 
On Tue, Aug 15, 2017 at 7:43 AM, Peter Geoghegan <pg@bowt.ie> wrote:

> On Mon, Aug 14, 2017 at 6:23 PM, Marko Tiikkaja <marko@joh.to> wrote:
> > Attached is a patch for $SUBJECT.  It might still be a bit rough around
> the
> > edges and probably light on docs and testing, but I thought I'd post it
> > anyway so I won't forget.
>
> Is it possible for ON CONFLICT DO SELECT to raise a cardinality
> violation error? Why or why not?


No.  I don't see when that would need to happen.  But I'm guessing you have
a case in mind?


.m

Commits

  1. Add support for INSERT ... ON CONFLICT DO SELECT.