ON CONFLICT issie detected

From: Irina Mileva <imileva(at)transfermate(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: ON CONFLICT issie detected
Date: 2017-04-21 11:40:54
Message-ID: B72BB4B6A2F58F4FABBE549335169E5C106B8A14@exch01-mbx02.taxback.ess.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2017-04-21 13:26:09 Re: Incorrect type in pg_cast causes Postmaster to core dump
Previous Message Greg Clough 2017-04-21 10:28:31 Incorrect type in pg_cast causes Postmaster to core dump