From: Tom Lane <tgl@sss.pgh.pa.us>
To: me nefcanto <sn.1361@gmail.com>
cc: Greg Sabino Mullane <htamfids@gmail.com>,
        "David G. Johnston" <david.g.johnston@gmail.com>,
        pgsql-general@lists.postgresql.org
Subject: Re: Please implement a catch-all error handler per row, for COPY
In-reply-to: <CAEHBEOBAYsELbjC7KvifHk00jNVJvCRpZkHDML9ebsP48g4w+A@mail.gmail.com>
References: <CAEHBEOCqqkSitU5gx=8aHD3ZeLtRy-1eC=Xs=xB-thFNR9JpYA@mail.gmail.com> <2961422.1740846012@sss.pgh.pa.us> <CAKFQuwbRCWP2DMHyW1LABuWAjDFVGE4mPJNfXOeTqzMpeBQ_Hw@mail.gmail.com> <CAKAnmm+OvPKF5p1vZ1FNs1AidJvBriT_+XBz8UZBpsNy7qiHWQ@mail.gmail.com> <CAEHBEOBAYsELbjC7KvifHk00jNVJvCRpZkHDML9ebsP48g4w+A@mail.gmail.com>
Comments: In-reply-to me nefcanto <sn.1361@gmail.com>
	message dated "Mon, 03 Mar 2025 07:14:52 +0330"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3558968.1740974847.1@sss.pgh.pa.us>
Date: Sun, 02 Mar 2025 23:07:27 -0500
Message-ID: <3558969.1740974847@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3558969.1740974847%40sss.pgh.pa.us>
Precedence: bulk

me nefcanto <sn.1361@gmail.com> writes:
> The point is, that there is already an `on_error ignore` clause there. This
> means that somewhere there is a try/catch per row. If I'm wrong, please let
> me know.

You are wrong.  See

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=d9f7f5d32

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=9e2d87011

and a ton of related commits.

It's possible that the specific case of unique-index violations
could be handled in a similar style.  But "catch any error whatever"
is simply not going to happen here, because a subtransaction per
row is not practical.

			regards, tom lane