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 1wP91h-000Tq0-2s for pgsql-hackers@arkaria.postgresql.org; Tue, 19 May 2026 01:13:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wP91f-003bFP-2a for pgsql-hackers@arkaria.postgresql.org; Tue, 19 May 2026 01:13:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wP91f-003bFH-1U for pgsql-hackers@lists.postgresql.org; Tue, 19 May 2026 01:13:40 +0000 Received: from mail-oo1-xc2c.google.com ([2607:f8b0:4864:20::c2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wP91e-00000000Hfd-1CX2 for pgsql-hackers@lists.postgresql.org; Tue, 19 May 2026 01:13:40 +0000 Received: by mail-oo1-xc2c.google.com with SMTP id 006d021491bc7-69b692871e0so1482749eaf.0 for ; Mon, 18 May 2026 18:13:38 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779153216; cv=none; d=google.com; s=arc-20240605; b=HPH8kb9ah1nJKRsj10EYPwrpR3OCxyQPHBP5q0QSR8HEGMruEdrKfAhlEvRxgppxeN 6EN7TxEuu0qx+/hPBICipKjYVXe3QUSSUF4aNORa/ZcmdKeQAcATerY8DvfhnmwFNjRN BuzqXi5faAs0NuMiUMznKBqJKTzEGlo069qSH5SCZnKjgfneL8sG+hATkbDCykAuO5TP syJF+iG3F5SrOfmHvde9tI7xSt8/4rjjm0ui+V3Z0QDR7bEcKq++nCcmqymGj30MzPRB zWtFCpuhKq+n1vsZwF++9iiHn6Qp8zq3a4cf+lBgZHR1p50HgSkpjXjQbZi2LkE1fcof Iakw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=wYUCZBvONNsA/OvqD7+wbWrLjOmAlHyxEzI40+zdyLc=; fh=UfTHo2VS1JWmr6EzZo136rqFWdAgMxDI/reaNNxjq+A=; b=jl0bo48BVY91D9O+KExidsiWYDVhIQHHfFWh1hWJDvA8Rbsf1SlrrqNRGG5y9us6ZD SVJd5GftML7NJgRK6Jo47+2C7StWHQFXZHSV5OkQ2alFq+6x68WukXUVOQJRdF0Bv2xY QOxnK8ZdGosSrN0fd+4O6rLZkIVIiiPi7+112J1tBmG1Du1i4AjW219IEDHEMQaQc9Hj eaQlcFJm0UpH1Q8knmk31Q3wVbtNG5bWaYQEXpzXupeb3MQbL8qpdGnbjx2uL36bQL8r NPm3ExU/IEk0wNE+kN48D8JS4Q9h3L75s8Ylk7u0iH+ZxKnCytX+0hD9MOWQwA8wvyTM zCUg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779153216; x=1779758016; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=wYUCZBvONNsA/OvqD7+wbWrLjOmAlHyxEzI40+zdyLc=; b=GdhJsNpmT1YCfxAvrlBQi3TxJCZ5DEMG3BiBdJQNcF9qm9h53D1KjKiaDBM+IKRm+n Ar1TYBelbPc0ztJWHGuImyzSJ/Y4AYBFA51X26g6tON995vXnQuuva0oxZiP6KXID3AN YrakqYeup+YaNMgL2sCTcfn9MZyrkDT+nIvkJn5noc2dS0HMgfUj9sQ4HQYvFOJDe9Ye d8YaBD/khVcDcvtah6LO6ybJAIMcSwIp+Qq65lG4mMZEufm8UpiUM7AgoHjUfi/GZM8x fesPvUChKh4dYiduArf8oTFfTYPrmady2T2XHlrefR+vNSldiW/GlUWETzzVrEyOlX6l +8lA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779153216; x=1779758016; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=wYUCZBvONNsA/OvqD7+wbWrLjOmAlHyxEzI40+zdyLc=; b=UAdgEe+CLV4VSidVTK+/EycwYVz2NJi6OgyL5eAMXoxvrY4GIwf1cUKoSWYKk1tDT3 JPYqBLd0b6I2yDUhxuBiDEtW7rGZW6euvDzW+K9k+jyDBoiO5FpJuigYKqFNW9kYeDOp GLrJKhzUrz8PKPyRgfU5eqzgMSnXq7a6KgWOs5jttUzvwM/+qomYNNT/bCjsXx1q/uuv 0yFfSe9i3SyTeeb8q4dzslDc+d6kNjjw5ZHYib0nQmgaDJ2RIylg4EdAE8AXabGEv+TC VmL54aiD+DKonOVDTyWhLMxtOKWwRmT1cF4y9jh9fk8Q/3r+x5ryO7zPk8ILjzkluoE/ cBUw== X-Forwarded-Encrypted: i=1; AFNElJ+zFeAL6g8JUrYJ90P9RiyNk6Hbj60nRnrpeJQwmioleJz3h9gOEAPg302+tXTXDnW+AHiHBbGyGY/9oP6h@lists.postgresql.org X-Gm-Message-State: AOJu0YwrNsaKFePFR7AuUGNAmlAE7v9JPI6AfqhERLR3OPrFvJ/ZhYm8 jDn3VXFd9TVuI5WtICl8OHUM+ojv5J9zDHU8xNjJC3f/KO0K0VzNV/xnKtsz8NgVmC/XhPGXtYX q0fhbWMELOthuT+Jqrse4Bq/VDtwY08U= X-Gm-Gg: Acq92OEWH2XKhvuJwbUi7+WvUFCis7PA5iKYNsPIyX5MxRizCrDToOI6PG06NfsM4pH 3PncdtQE098sRS/QiTxQKuG1YiPEftUxx5rx/kGuIPgZNoCgMVQlk+ziqk86llBqpJjHSM+r5mO d+oaWk9qUkS7YOc85brxjXdbbS7YAMTZ40IzjofWjDpisyD2XssGVn8/kpHH5DgrBcsa3q2n6li e/L+Ecos+/VdjVMqxcivuhRMSzGgN84POROB35jWaWME8eIskGlBNUqNxo6Yey68QKutDmb95SK J864wRBtcp7rKGTQqZ5wZJ+IA6WLuHw0/vrRk9yRSQ== X-Received: by 2002:a05:6820:828e:b0:69d:d07:db6 with SMTP id 006d021491bc7-69d0d0711b0mr6651207eaf.42.1779153216508; Mon, 18 May 2026 18:13:36 -0700 (PDT) MIME-Version: 1.0 References: <0ED082D4-70CB-4144-8A00-EFE63FCC15B1@gmail.com> In-Reply-To: <0ED082D4-70CB-4144-8A00-EFE63FCC15B1@gmail.com> From: Fujii Masao Date: Tue, 19 May 2026 10:13:22 +0900 X-Gm-Features: AVHnY4JgEdjW2xtKGSh56-11hjOq_B0F5rI1HON0-t3ISo0Hlh818wGWIc4tWhk Message-ID: Subject: Re: COPY FROM ON_ERROR SET_NULL bypasses domain NOT NULL with partial column list To: Chao Li Cc: jian he , SATYANARAYANA NARLAPURAM , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, May 19, 2026 at 7:28=E2=80=AFAM Chao Li wr= ote: > I also found this bug and reported it here [1]. I just reviewed v2, the c= ode change of the fix itself is exactly the same as my version in [1]. The = new test is slightly different from my version, but I think that also works= . Thanks for the review! I've pushed the patch. Regards, --=20 Fujii Masao