Re: [BUGS] ON CONFLICT issie detected

Поиск
Список
Период
Сортировка
Искать
От
Peter Geoghegan
Тема
Re: [BUGS] ON CONFLICT issie detected
Дата
Msg-id
CAH2-WzkCxJRJ4BW_fRuhkXxFQHGmv_WZEbs20jaXzFeDDHDFig@mail.gmail.com
Ответ на
[BUGS] ON CONFLICT issie detected (Irina Mileva)
Список
Дерево обсуждения
[BUGS] ON CONFLICT issie detected Irina Mileva <imileva@transfermate.com>
Re: [BUGS] ON CONFLICT issie detected Peter Geoghegan <pg@bowt.ie>
Re: [BUGS] ON CONFLICT issie detected Irina Mileva <imileva@transfermate.com> 
On Fri, Apr 21, 2017 at 4:40 AM, Irina Mileva  wrote:
> “ON CONFLICT (columnName) DO UPDATE” do NOT works with FOREIGN TABLES
>
> Returns:
>
> “ERROR: there is no unique or exclusion constraint matching the ON CONFLICT
> specification”

It's unsupported, because there is no such thing as a foreign unique
constraint. Only ON CONFLICT DO NOTHING will work against a foreign
table, and only when an arbiter constraint is not inferred.

See the docs on INSERT.


-- 
Peter Geoghegan

VMware vCenter Server
https://www.vmware.com/


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
В списке pgsql-bugs по дате отправления
Предыдущее
От: Tom Lane
Дата:
Следующее
От: Irina Mileva
Дата:
FAQ