Re: Bug in copy

On Fri, Feb 7, 2025 at 10:28 PM me nefcanto <sn(dot)1361(at)gmail(dot)com> wrote:

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

While the would be a possible definition to implement what actually is
implemented is:

"Specifies how to behave when encountering an error converting a column's
input value into its data type."

Thus the observed behavior is not a bug.

David J.