| From: | Irina Mileva <imileva(at)transfermate(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: ON CONFLICT issie detected |
| Date: | 2017-04-21 17:44:01 |
| Message-ID: | B72BB4B6A2F58F4FABBE549335169E5C106C03A5@exch01-mbx02.taxback.ess.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Many thanks!
Sent with AquaMail for Android
http://www.aqua-mail.com
On 21 април 2017 г. 19:15:58 Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | buschmann | 2017-04-21 18:40:12 | BUG #14629: ALTER TABLE VALIDATE CONSTRAINTS does not obey NO INHERIT clause |
| Previous Message | Peter Geoghegan | 2017-04-21 16:15:32 | Re: ON CONFLICT issie detected |