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
|
| Список | 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
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 по дате отправления: