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
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 |