Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1toQQp-00AZxx-29
	for pgsql-general@arkaria.postgresql.org; Sat, 01 Mar 2025 17:15:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1toQQp-0000hd-CR
	for pgsql-general@arkaria.postgresql.org; Sat, 01 Mar 2025 17:15:17 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <htamfids@gmail.com>)
	id 1toQQp-0000hU-1O
	for pgsql-general@lists.postgresql.org; Sat, 01 Mar 2025 17:15:17 +0000
Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <htamfids@gmail.com>)
	id 1toQQl-000NcD-0N
	for pgsql-general@lists.postgresql.org;
	Sat, 01 Mar 2025 17:15:16 +0000
Received: by mail-io1-xd2c.google.com with SMTP id ca18e2360f4ac-8553e7d9459so89605939f.2
        for <pgsql-general@lists.postgresql.org>; Sat, 01 Mar 2025 09:15:15 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1740849314; x=1741454114; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=J6kMpaSuNv1uFMMAD+s7Wgi960YSjV2rXrzfokmcLhE=;
        b=afJApOwfTxxuYYM1Gsuep/Kq2eH+NAATv+FhKlbhJvow8IJ3Dq3I+3pwOoFtrS+t9J
         EcZ2pimK5xddFX8HkZjO5cOStBz+LL6FUqlw7rlhJnCHSJ5vCur4rN2isGtciCCfRm52
         f7ig7zhhcw4WebTmZ8D8Gfk9xBoIrX+7ZU5ivMIXvMOo87nrt5Z8dqq0TqcVruvbP/ZO
         j4ScWZVbtruybTqdIHVsfVRtC7xczr34DJyV6llZTXCLt4GClYzRkizYPbtD7sz3YgfF
         4LCqIA6FJnkZ2YyL7nFJIV9Y5yUnh2qy4OThtvzaETJD5b8zyDhyFpoSkddg9Sf62ade
         YzVQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1740849314; x=1741454114;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=J6kMpaSuNv1uFMMAD+s7Wgi960YSjV2rXrzfokmcLhE=;
        b=rZ7L9h1AXsv+uEnGT+31b9NMwq47YyjsbqiQYoz6XDz+D/TlW0V1n8l9NqxJ88OvsJ
         IkMG94Au+GrIy1aMbvfT/jJHBQU0eg1jbQIzMl1qwZ+t+Z/iPgpu5IdPAsoqBeWR5XV+
         FUeUpc5g3KBCiGD0WdB2QgGw0OTPCTfsSfA6JY7N4+CGt20SiEw0nVrwVpP6trNkI8la
         LMy7MdztjfE4l1/f0J6Zn0YRk7hW3jFRixvaEIjIVLRI2j58RCGwXrBSjy2j6laHlfS7
         nhe3xLlE4DNdfIKvqw+iqOdS0QK2LjOZB2xrPhmDNssCHoDi0ocGFy/dZ2Te7KYSyflI
         ctGg==
X-Forwarded-Encrypted: i=1; AJvYcCW6M0LTNFClWqKmVkpHN3iRBCzTWvx55fb8a2fOV3od3SaJaRnpZHbydkrG+aT9Gp1ryVKtMTZH8OJq6ft6@lists.postgresql.org
X-Gm-Message-State: AOJu0Yy/F1n6NVIFHNMBe3Cm5ugdqHMosAdf6BiTyIzXQQwVx1kkiytS
	J4NaEU/KXV6bevLkjRm8RyLgSlxRq2XNseDjxryikhSgCeiQQLUW3RraYqLpTBphXPvgneSdVru
	R3S7NYYehueX1FIlc4xHHH7XDHMU=
X-Gm-Gg: ASbGncsT/KPw+ME62CewDp5zMD3IzQxeRXboveuZrFpsIip6KexAVHCfq6M8Xgbhj/9
	e6QWJyRHiEvpkAR+qBSyHor86PEhloXxsXVIZsCF3L4RWltSWMBvi1BmUTUDNvxTtYlhfEK0W1T
	qepj5djOkz2phYakkrtOwY+KFkn7pymYcK2Xn36AWihcwE/vazoiCyiZl4xY76
X-Google-Smtp-Source: AGHT+IFDz+7q+mnGTCBOHT91SW//0xRaLPomSYJy59a26fjTZTaQ4pJTMkDBs6/5VliwWDHSjMbkN2QU23pTp+Yt1Zs=
X-Received: by 2002:a05:6e02:12ea:b0:3d3:dfb6:2203 with SMTP id
 e9e14a558f8ab-3d3e6f4a094mr68299645ab.19.1740849314155; Sat, 01 Mar 2025
 09:15:14 -0800 (PST)
MIME-Version: 1.0
References: <CAEHBEOCqqkSitU5gx=8aHD3ZeLtRy-1eC=Xs=xB-thFNR9JpYA@mail.gmail.com>
 <2961422.1740846012@sss.pgh.pa.us> <CAKFQuwbRCWP2DMHyW1LABuWAjDFVGE4mPJNfXOeTqzMpeBQ_Hw@mail.gmail.com>
In-Reply-To: <CAKFQuwbRCWP2DMHyW1LABuWAjDFVGE4mPJNfXOeTqzMpeBQ_Hw@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Sat, 1 Mar 2025 12:14:37 -0500
X-Gm-Features: AQ5f1JqatXqaqCD9FPmdI9_4PaVJnQErCFIpuogVACHBWD5EYg7zMK53pThYT80
Message-ID: <CAKAnmm+OvPKF5p1vZ1FNs1AidJvBriT_+XBz8UZBpsNy7qiHWQ@mail.gmail.com>
Subject: Re: Please implement a catch-all error handler per row, for COPY
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, me nefcanto <sn.1361@gmail.com>, 
	pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000fa59ac062f4b10e7"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAKAnmm%2BOvPKF5p1vZ1FNs1AidJvBriT_%2BXBz8UZBpsNy7qiHWQ%40mail.gmail.com>
Precedence: bulk

--000000000000fa59ac062f4b10e7
Content-Type: text/plain; charset="UTF-8"

FYI the -bugs thread in question:

https://www.postgresql.org/message-id/flat/CAEHBEOBCweDWGNHDaUk4%3D10HG0QXXJJAGXbEnFLMB30M%2BQw%2Bdg%40mail.gmail.com

seems to imply the primary blocker was a unique constraint.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--000000000000fa59ac062f4b10e7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">FYI the -bugs thread in question:<div><br=
></div><div><a href=3D"https://www.postgresql.org/message-id/flat/CAEHBEOBC=
weDWGNHDaUk4%3D10HG0QXXJJAGXbEnFLMB30M%2BQw%2Bdg%40mail.gmail.com">https://=
www.postgresql.org/message-id/flat/CAEHBEOBCweDWGNHDaUk4%3D10HG0QXXJJAGXbEn=
FLMB30M%2BQw%2Bdg%40mail.gmail.com</a></div><div><br></div><div>seems to im=
ply the primary blocker was a unique constraint.</div><div><br></div><div>C=
heers,</div><div>Greg</div><div><br></div></div><div dir=3D"ltr" class=3D"g=
mail_signature"><div dir=3D"ltr"><div>--</div><div>Crunchy Data - <a href=
=3D"https://www.crunchydata.com" target=3D"_blank">https://www.crunchydata.=
com</a></div><div>Enterprise Postgres Software Products &amp; Tech Support<=
/div><div><br></div></div></div></div>

--000000000000fa59ac062f4b10e7--