On Fri, Apr 21, 2017 at 4:40 AM, Irina Mileva <imileva(at)transfermate(dot)com> 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/