Bug in copy

From: me nefcanto <sn(dot)1361(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Bug in copy
Date: 2025-02-08 05:28:22
Message-ID: CAEHBEOBCweDWGNHDaUk4=10HG0QXXJJAGXbEnFLMB30M+Qw+dg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello

I run this command:

copy "Parts" ("Id","Title") from stdin with (format csv, delimiter ",",
on_error ignore)

But I receive this error:

duplicate key value violates unique constraint "PartsUniqueLocaleTitle"

This means that the on_error setting is not working. When I try to insert a
million records, this becomes extremely annoying and counterproductive.

When we specify that on_error should be ignored, any type of error
including data type inconsistency, check constraint inconsistency, foreign
key inconsistency, etc. should be ignored and Postgres should move to the
next record and not fail the entire bulk operation.

Regards
Saeed Nemati

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2025-02-08 05:45:02 Re: Bug in copy
Previous Message PG Bug reporting form 2025-02-07 23:30:49 BUG #18800: Error while using pg_combinebackup