Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors
Date: 2015-05-25 00:41:23
Message-ID: CAM3SWZT_rRKwviYwZCqEkQgX9My4Ex++31kJ1BjCjnE54EdavA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, May 24, 2015 at 5:16 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
> AddForeignUpdateTargets() actually won't be called with ON CONFLICT DO
> UPDATE, and so it isn't exactly true that the only obstacle to making
> FDWs support ON CONFLICT DO UPDATE is around inference of arbiter
> unique indexes on the foreign side. It's *almost* true, though.

Attached patch clears this up within the fdw-handler documentation. I
think it's worth separately noting from the existing commentary on
limitations with FDWs and ON CONFLICT.

--
Peter Geoghegan

Attachment Content-Type Size
fdw-handler-arbiter-note.patch text/x-patch 616 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2015-05-25 01:01:54 Re: problems on Solaris
Previous Message Peter Geoghegan 2015-05-25 00:16:24 Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors