Horton
Menu

Re: ON CONFLICT DO NOTHING ignored on bulk insert

Geoff Winkless <pgsqladmin@geoff.dj>

View thread
From: Geoff Winkless <pgsqladmin@geoff.dj>
To: Andrus <kobruleht2@hot.ee>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2021-05-25T08:29:17Z
Lists: pgsql-general 
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