Add new COPY option REJECT_LIMIT

From: torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Add new COPY option REJECT_LIMIT
Date: 2024-01-26 09:49:10
Message-ID: 63f99327aa6b404cc951217fa3e61fe4@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

9e2d870 enabled the COPY command to skip soft error, and I think we can
add another option which specifies the maximum tolerable number of soft
errors.

I remember this was discussed in [1], and feel it would be useful when
loading 'dirty' data but there is a limit to how dirty it can be.

Attached a patch for this.

What do you think?

[1]
https://www.postgresql.org/message-id/752672.1699474336%40sss.pgh.pa.us

--
Regards,

--
Atsushi Torikoshi
NTT DATA Group Corporation

Attachment Content-Type Size
v1-0001-Add-new-COPY-option-REJECT_LIMIT.patch text/x-diff 6.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Anthonin Bonnefoy 2024-01-26 10:17:39 Re: POC: Extension for adding distributed tracing - pg_tracing
Previous Message Yugo NAGATA 2024-01-26 09:30:05 Re: Small fix on COPY ON_ERROR document