Re: ON CONFLICT DO NOTHING ignored on bulk insert

https://www.postgresql.org/docs/11/sql-insert.html#SQL-ON-CONFLICT

"The optional ON CONFLICT clause specifies an alternative action to raising
a *unique violation or exclusion constraint violation* error."

El mar, 25 de may. de 2021 a la(s) 03:29, Geoff Winkless (
pgsqladmin@geoff.dj) escribió:

> On Tue, 25 May 2021 at 08:18, Andrus <kobruleht2@hot.ee> wrote:
>
>> Looking for a method to do bulk insert ignoring product foreign key
>> mismatches.
>>
> ON CONFLICT only works with unique constraints, it's not designed for what
> you're trying to use it for.
>
> Geoff
>


-- 
Cordialmente,

Ing. Hellmuth I. Vargas S.
Esp. Telemática y Negocios por Internet
Oracle Database 10g Administrator Certified Associate
EnterpriseDB Certified PostgreSQL 9.3 Associate