Postgres Pro
Downloads
Home   >   mailing lists

Re: ON CONFLICT DO NOTHING ignored on bulk insert - Mailing list pgsql-general

From Geoff Winkless
Subject Re: ON CONFLICT DO NOTHING ignored on bulk insert
Date
Msg-id CAEzk6fe+0YkDAKXj8DU2iEQFLWUiehkJQ0jsiOfYWAgqnwwfrA@mail.gmail.com
Whole thread Raw
In response to ON CONFLICT DO NOTHING ignored on bulk insert  (Andrus <kobruleht2@hot.ee>)
Responses Re: ON CONFLICT DO NOTHING ignored on bulk insert
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Andrus
Date:
Subject: ON CONFLICT DO NOTHING ignored on bulk insert
Next
From: Simon Connah
Date:
Subject: Re: I have no idea why pg_dump isn't dumping all of my data