Re: INSERT ... ON CONFLICT syntax issues

On 2015-05-04 14:16:42 -0700, Peter Geoghegan wrote:
> On Sun, Apr 26, 2015 at 2:22 AM, Heikki Linnakangas <hlinnaka@iki.fi> wrote:
> > The ability to specify a constraint by name hasn't been implemented, but
> > that would read quite naturally as:
> >
> > INSERT INTO mytable ON CONFLICT ON CONSTRAINT my_constraint UPDATE ...
> 
> For the record, I have made this change on Github

Theoretically this changes the pictures for FDWs, right? Right now
there's
+    <para>
+     <command>INSERT</> with an <literal>ON CONFLICT</> clause is not
+     supported with a unique index inference specification, since a
+     conflict arbitrating unique index cannot meaningfully be inferred
+     on a foreign table (this implies that <literal>ON CONFLICT DO
+     UPDATE</> is never supported, since the specification is
+     mandatory there).
+    </para>
but theoretically the constraint name could be meaningful on the other
side...

I don't think this is anyting for 9.5, but it might be interesting for
later.

Greetings,

Andres Freund