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.96) (envelope-from ) id 1vxJNo-007uLb-26 for pgsql-committers@arkaria.postgresql.org; Tue, 03 Mar 2026 06:37:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxJNn-005347-03 for pgsql-committers@arkaria.postgresql.org; Tue, 03 Mar 2026 06:37:27 +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.96) (envelope-from ) id 1vxJNm-00533z-2b for pgsql-committers@lists.postgresql.org; Tue, 03 Mar 2026 06:37:27 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vxJNl-000000008ZN-2FdI for pgsql-committers@lists.postgresql.org; Tue, 03 Mar 2026 06:37:26 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vxJNl-006BVH-1K for pgsql-committers@lists.postgresql.org; Tue, 03 Mar 2026 06:37:25 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxJNl-0027u6-0b for pgsql-committers@lists.postgresql.org; Tue, 03 Mar 2026 06:37:25 +0000 Content-Type: multipart/mixed; boundary="===============5490050093526045966==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add COPY (on_error set_null) option X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 03 Mar 2026 06:37:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5490050093526045966== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIENPUFkgKG9uX2Vycm9yIHNldF9udWxsKSBvcHRpb24KCklmIE9OX0VSUk9SIFNFVF9OVUxM IGlzIHNwZWNpZmllZCBkdXJpbmcgQ09QWSBGUk9NLCBhbnkgZGF0YSB0eXBlCmNvbnZlcnNpb24g ZXJyb3JzIHdpbGwgcmVzdWx0IGluIHRoZSBhZmZlY3RlZCBjb2x1bW4gYmVpbmcgc2V0IHRvIGEK bnVsbCB2YWx1ZS4gIEEgY29sdW1uJ3Mgbm90LW51bGwgY29uc3RyYWludHMgYXJlIHN0aWxsIGVu Zm9yY2VkLCBhbmQKYXR0ZW1wdGluZyB0byBzZXQgYSBudWxsIHZhbHVlIGluIHN1Y2ggY29sdW1u cyB3aWxsIHJhaXNlIGEgY29uc3RyYWludAp2aW9sYXRpb24gZXJyb3IuICBUaGlzIGFwcGxpZXMg dG8gYSBjb2x1bW4gd2hvc2UgZGF0YSB0eXBlIGlzIGEgZG9tYWluCndpdGggYSBOT1QgTlVMTCBj b25zdHJhaW50LgoKQXV0aG9yOiBKaWFuIEhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+ CkF1dGhvcjogS2lyaWxsIFJlc2hrZSA8cmVzaGtla2lyaWxsQGdtYWlsLmNvbT4KUmV2aWV3ZWQt Ynk6IEZ1amlpIE1hc2FvIDxtYXNhby5mdWppaUBvc3MubnR0ZGF0YS5jb20+ClJldmlld2VkLWJ5 OiBKaW0gSm9uZXMgPGppbS5qb25lc0B1bmktbXVlbnN0ZXIuZGU+ClJldmlld2VkLWJ5OiAiRGF2 aWQgRy4gSm9obnN0b24iIDxkYXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6 IFl1Z28gTkFHQVRBIDxuYWdhdGFAc3Jhb3NzLmNvLmpwPgpSZXZpZXdlZC1ieTogdG9yaWtvc2hp YSA8dG9yaWtvc2hpYUBvc3MubnR0ZGF0YS5jb20+ClJldmlld2VkLWJ5OiBNYXNhaGlrbyBTYXdh ZGEgPHNhd2FkYS5tc2hrQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEF0c3VzaGkgVG9yaWtvc2hp IDx0b3Jpa29zaGlhQG9zcy5udHRkYXRhLmNvbT4KUmV2aWV3ZWQtYnk6IE1hdGhldXMgQWxjYW50 YXJhIDxtYXRoZXVzc3NpbHY5N0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBQZXRlciBFaXNlbnRy YXV0IDxwZXRlckBlaXNlbnRyYXV0Lm9yZz4KRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdy ZXNxbC5vcmcvbWVzc2FnZS1pZC9mbGF0L0NBS0ZRdXdhd3kxZTZZUjRTJTNEaiUyQnk3cFhxZ19E dzFXQlZyZ3ZmJTNEQlAzZDFfYVNmZV8lMkJRJTQwbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0t LS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcv Y29tbWl0ZGlmZi8yYTUyNWNjOTdlMTk4Njg5NDBjNTMzNzg3MTY1YmM3ZTdkZTNhODBhCgpNb2Rp ZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5zZ21sICAg ICAgICAgICAgIHwgIDQgKy0KZG9jL3NyYy9zZ21sL3JlZi9jb3B5LnNnbWwgICAgICAgICAgICAg ICB8IDMwICsrKysrKystLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2NvcHkuYyAgICAgICAgICAg ICAgfCAgNyArKy0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvY29weWZyb20uYyAgICAgICAgICB8IDU0 ICsrKysrKysrKysrKysrKy0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2NvcHlmcm9tcGFyc2Uu YyAgICAgfCA4OCArKysrKysrKysrKysrKysrKysrKysrKysrKystLS0tLQpzcmMvYmluL3BzcWwv dGFiLWNvbXBsZXRlLmluLmMgICAgICAgICAgIHwgIDIgKy0Kc3JjL2luY2x1ZGUvY29tbWFuZHMv Y29weS5oICAgICAgICAgICAgICB8ICAxICsKc3JjL2luY2x1ZGUvY29tbWFuZHMvY29weWZyb21f aW50ZXJuYWwuaCB8ICA3ICsrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NvcHkyLm91dCAg ICAgIHwgNTggKysrKysrKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NvcHky LnNxbCAgICAgICAgICAgfCA0MyArKysrKysrKysrKysrKysrCjEwIGZpbGVzIGNoYW5nZWQsIDI1 MyBpbnNlcnRpb25zKCspLCA0MSBkZWxldGlvbnMoLSkKCg== --===============5490050093526045966==--