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

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors
Дата
Msg-id 5566CFE5.6030902@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors  (Peter Geoghegan <pg@heroku.com>)
Ответы Re: Re: 9.5 release notes may need ON CONFLICT DO NOTHING compatibility notice for FDW authors  (Peter Geoghegan <pg@heroku.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Add pg_audit, an auditing extension
Следующее
От: Jeevan Chalke
Дата:
Сообщение: pg_get_functiondef() does not show LEAKPROOF for leakproof functions