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

From Etsuro Fujita
Subject Re: Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors
Date
Msg-id 5566CFE5.6030902@lab.ntt.co.jp
Whole thread Raw
In response to Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors  (Peter Geoghegan <pg@heroku.com>)
Responses Re: Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
On 2015/05/25 9:16, Peter Geoghegan 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.

I think that those are interesting problems.  Wouldn't we need some 
additional hacks for the core or FDW to perform an operation that is 
equivalent to dynamically switching the ExecInsert/ExecForeignInsert 
processing to the ExecUpdate/ExecForeignUpdate processing in case of a 
conflict?

Best regards,
Etsuro Fujita



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [COMMITTERS] pgsql: Add pg_audit, an auditing extension
Next
From: Jeevan Chalke
Date:
Subject: pg_get_functiondef() does not show LEAKPROOF for leakproof functions