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 1wFShC-0059Ga-2z for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Apr 2026 08:12:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wFShC-00CQkm-04 for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Apr 2026 08:12:30 +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 1wFShB-00CQkc-1u for pgsql-hackers@lists.postgresql.org; Wed, 22 Apr 2026 08:12:29 +0000 Received: from mail-qk1-x729.google.com ([2607:f8b0:4864:20::729]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wFSh9-00000002DjF-23Sh for pgsql-hackers@lists.postgresql.org; Wed, 22 Apr 2026 08:12:28 +0000 Received: by mail-qk1-x729.google.com with SMTP id af79cd13be357-8e0a768331cso616181385a.0 for ; Wed, 22 Apr 2026 01:12:27 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776845547; cv=none; d=google.com; s=arc-20240605; b=L3HngdfHbyMOIh3zn7hD/R4i7T2VSomoIiJlyu4IdcmbbkRiQYowwqYqrD2kbQi3yz A5ZPqWfEyf/CwWKHxP9qp+d1/E9BEY289LtbnR9354fzWIrKCxswfkMexyTOPbCRH0vm 87h4jOoCNaJf5vGn2GKrR2FVoeoW7a4jJ57Fjv7WMsPj457oQjmzx0/g3fDhwODiTEEe faN+5S53x8dN39oXR1iUUeMuZ2AhN9HK9PtRYkxlxmSFgZ/yqQr8tu48+C1XOhFOOl1Q +L6EIc9v7wjkyN6oczjY/1CO3tfV2y9ZV82KnJXi9I5qjnnu7sKvz7Wg7AdqTfODKR/l oAQA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=kocmkl+hyCt9SSoPGicdoA6oUjTJIO7oRMpD5IP7xCI=; fh=PDhzRmLFhJQgKl2kpY6iqaoiggk+rKjB8rXL7ERgOws=; b=Mf4sO7sEXgBHutQSm9WHiwxtZ0xrzXigZzVfdWha0txFAi1WR/RbjvfPlSmdOmoLO9 Wy+4rRAOQLMuITytX3Qfr7vX0r3sINf03R/VtluD0gDStTXPww+SMwzq9iNqRdwFesw0 E20WVfZlwwtbQpRHJr56GMlgfjNFXgbnGIw4kpSDEPhz+W3b2/AdJCLSI8ua9t/+QUci mkmUaCkDp/egbCVcuj92lDAM1SBMBjtbj/S5bI69tklyK/qWj9HGiV1kPfDHXPfqjnCF zGQbIHXp4/TQ9BKP4VWSla4uH6HgtNeisM1chzR47pU2ekXCHJHnvWmAgtVNN13u7iOY aucA==; 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=1776845547; x=1777450347; 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=kocmkl+hyCt9SSoPGicdoA6oUjTJIO7oRMpD5IP7xCI=; b=eiYl4dKfj9v5wYhC8C6PNg6OqWTA+ev0DEFkvNu9P37Ejw7/oysEXwh0JknvS+z/27 VzVufGB+el57GRFFGAuuqHp/jCUtw9TmHFUpJ2xp8dQe16hXYcb8VitkI06tKq0cBL/6 RAzbXTGeN9WcHrZe2qr0pZxQF+WgdgJ9x4RK7tjsbl/6d0l3H0zCWaM62KT0tea49rct Q4rfzt0zE2UBseUNPAtL7Ke5D1lEpmd7xoBXlP4K/C1hM3z+8kbLuJj7jxRQ3oYMg7Ld UgXshzE/hHoC0mWVBPmTZa1q2nvZbm4xff8DpYB6VFCfaHELjqLAU0MKqMGUqgk8/fjm tflw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776845547; x=1777450347; h=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=kocmkl+hyCt9SSoPGicdoA6oUjTJIO7oRMpD5IP7xCI=; b=syv9B/iVe7sb33NWInSzSNBXy/jle5PZYdYnKLvL+iJ9COSc7XczugocYlJqOXfnYx P5R9W7JgsrNBnDTDgE49jHsnLw2FKz9erUBvwjsegW/67u1DvOrhN3TYvVgWwIL6tfRr ThzSE+tLF9nGhFb7pXffWyNq3X4PX0WaB7Y7wOCN/gX0hQ2aYVQETCkNpuaYmU9DKWyV s/9ZFPJptKxHS7JTis9Dr15NWjIfqwoCK6u3UQ2eIJjVHRCMjHVTsL5YHG1QNZPPVCMW 3ZCWkzJT2X6Nxi8nbNN/mHGFblISrQRXjQsOZJNIcR4mO8VatcDqEo9lLURHIdhPVC39 0czg== X-Gm-Message-State: AOJu0YwH3to351omWj8MbHOEUjxKMl1TUDrRxMnaKsoE2upDPAGSyfXE w+7XPSZb2lXPUvilVBtS7oNt6pXMaEJg92M+7H488La2L+u4/nHp9nHA5qAtdSLnBQbPdC1ur5D BJaQsAcaaWV+q34oZHTyPuggZ0giczfo= X-Gm-Gg: AeBDievFml0iPGnE3TuhL5dIRbDilkS7BvAgaLDboTlVEq8vDtKjSs+jkmLqSBR39BR 753wJNaxD1nneYLFhS3p4NieTJvRCkUdw8HJLAIdgjUeNbfMYZ0oR/F1e2SvJT216lQZXTUR/7w BWqU8S4aYPcyZ9xD436Wz1A5u6zfBiP9yuLMwn4t2zL6qj9tvQamWcSL/IfBlAfCltROQUd3EWl +BMOmC9SpW67IxYePsnlg5p7X73MXPCjzLvlaKQFX2ITOaP8t21E1noMoP0r1NWJ6SnecuifGgV zCjOMzg8HFRO0gEexFkUq2bkuJwVFY5pc9eHongjiOqSF/BgLV+N X-Received: by 2002:ac8:5e4a:0:b0:50b:4a3c:8917 with SMTP id d75a77b69052e-50e36738debmr275080681cf.24.1776845546875; Wed, 22 Apr 2026 01:12:26 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dean Rasheed Date: Wed, 22 Apr 2026 09:12:15 +0100 X-Gm-Features: AQROBzATM8c32nHGMCUfxNDU09Xd27_JhcWXovLtI6jH3gki2FWTlkW886vuPsc Message-ID: Subject: Re: [BUG] ON CONFLICT DO UPDATE SET x = EXCLUDED. errors or silently writes NULL To: SATYANARAYANA NARLAPURAM Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 20 Apr 2026 at 01:55, SATYANARAYANA NARLAPURAM wrote: > >> Attached is a v2 patch doing it that way, with the same tests, which all pass. > > Reran the failing tests and they all passed. Additionally ran the regression tests. > Patch looks good to me. > Thanks for checking. Patch pushed and back-patched to v18. Regards, Dean