Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors - Mailing list pgsql-hackers

From Albe Laurenz
Subject Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors
Date
Msg-id A737B7A37273E048B164557ADEF4A58B36615D35@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors  (Peter Geoghegan <pg@heroku.com>)
List 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

pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: problems on Solaris
Next
From: Paul Smith
Date:
Subject: ERROR: MultiXactId xxxx has not been created yet -- apparent wraparound