From: Daniel Topalov
Sent: 21 April 2017 14:25
To: Irina Mileva
Subject: ON CONFLICT issue detected
“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”
“ALTER FOREIGN TABLE tableName
ADD CONSTRAINT ConstName UNIQUE (columnName);”
Returns:
“ERROR: unique constraints are not supported on foreign tables”