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

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Peter Geoghegan *EXTERN*'" <pg(at)heroku(dot)com>, 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-26 08:20:53
Message-ID: A737B7A37273E048B164557ADEF4A58B36615D35@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Geoghegan wrote:
> In any case, third party foreign data wrappers that target other
> database system will totally ignore ON CONFLICT DO NOTHING when built
> against the master branch (unless they consider these questions). They
> should perhaps make a point of rejecting DO NOTHING outright where it
> makes sense that support could exist, but it just doesn't. Or they
> could just add support (I imagine that this would be very easy for
> mysql_fdw, for example -- MySQL has INSERT IGNORE). I feel a
> compatibility item in the release notes is in order so the question is
> considered, but there seems to be no place to do that on the Wiki, and
> the original commit message does not have a note like this.

+1

I wouldn't have become aware of that if I hadn't read your message.

Yours,
Laurenz Albe

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hans Ginzel 2015-05-26 08:57:53 psql readline Tab insert tab
Previous Message Dave Page 2015-05-26 08:10:28 Re: problems on Solaris