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 ( pgsqlad...@geoff.dj) escribió: > On Tue, 25 May 2021 at 08:18, Andrus <kobrule...@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
