Re: ON CONFLICT DO NOTHING ignored on bulk insert

Поиск
Список
Период
Сортировка
От Hellmuth Vargas
Тема Re: ON CONFLICT DO NOTHING ignored on bulk insert
Дата
Msg-id CAN3Qy4obiv4xnqFNAw7V+1b2u2RPC+gRn1ww+T4QmkjE6ftHhA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ON CONFLICT DO NOTHING ignored on bulk insert  (Geoff Winkless <pgsqladmin@geoff.dj>)
Ответы Re: ON CONFLICT DO NOTHING ignored on bulk insert  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-general
Дерево обсуждения


"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

В списке pgsql-general по дате отправления:

Предыдущее
От: Poul Kristensen
Дата:
Сообщение: Re: Simple question from a beginner: Can I use PostgreSQL as a file database?
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: ON CONFLICT DO NOTHING ignored on bulk insert