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 1vXzU7-00B7EO-10 for pgsql-docs@arkaria.postgresql.org; Tue, 23 Dec 2025 10:19:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vXzU6-001BaD-0t for pgsql-docs@arkaria.postgresql.org; Tue, 23 Dec 2025 10:19:19 +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 1vXzU6-001Ba4-0A for pgsql-docs@lists.postgresql.org; Tue, 23 Dec 2025 10:19:18 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vXzU5-002AVD-1n for pgsql-docs@lists.postgresql.org; Tue, 23 Dec 2025 10:19:17 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-47775fb6cb4so30126695e9.0 for ; Tue, 23 Dec 2025 02:19:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1766485154; x=1767089954; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=EYuCNOLWP/hLK89z1VFEAQx0/Eg9HWW35Aiksv2fN6g=; b=cmu3JssVExjJBaZ7pg20KFhgWvujVMTqNeLIX3uff7mKJ8EoIRwjNAhcJL4Sv57FQG Dn7Qo07DyhIrzRQl2oLMy/MZc/c+U+fGrGTBYQ199TYGGKz+e7eaY2hpaK3zMdYe/J8Q zXAeT/NTN3iI8EkHaca2TDwTwSVfHjr2ciwQah/cU+ma4H+3idcE/yjRm5WpO6FHsfY5 46lCuN3jFRtqa+R7n8epK6z4azzS3DcjVMdH/JsYwIUxlQSt05MWqTUAQCb7yjNksPvD hbFAGZtn0lVIir9fcfbr4Ym85K5k/5Sj6OlbOAXTPjjfKqLLS+Dg9CB8pvzNP/9yLanL /TOw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766485154; x=1767089954; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=EYuCNOLWP/hLK89z1VFEAQx0/Eg9HWW35Aiksv2fN6g=; b=EijlCCllgz5PILnpvwv4ifpCPthJOFOVHPXXkWyyd/AxBPnfaVYwCjlmg3UcjuQ4nN xLfcaAvHV4yJRnM+eZgt1sT+D9HreotohwFglcf+TaPAJpVD9folQlR0ceBqnF45qaP+ LoiLfgwOMyUeOLO019WrmAIPLTBUOElYGUvNikqfxttVYy368d+HH10wbBcKCpfq/+SU 81MZ+2EGPs0BUcuJJsMdf/IOKcVm8prrAgbSgra9y1qjNu+FZXjLJyOrMDAsxWj1ce5N ebs9CxlSEiyaei8auaP8TAXpT9XpG05Qdpv9dx66pG6LXNwoR/oREKj76g07PhZMnZJ6 1GSw== X-Forwarded-Encrypted: i=1; AJvYcCURVIEK5YpqWwidcOx57HLYSnppwUZklNWw1A3serG0W9Nskqq/FsynO2g2uli85Q0myCuBJ5wx/JGn@lists.postgresql.org X-Gm-Message-State: AOJu0YzntjafgLmZjlVoMj7qB8JN+R5VSY9+0e97Ryj1aCZCS02YcBQC 9rxuk7t/BEJbqzhi/ImABht0w9CTOaLJeynDmSUtRl44q1IJtUTDuKwJ9MZr+/y5acI= X-Gm-Gg: AY/fxX6Qw/t9pLUmlUqdR/qmuOWWe/7lMobfZ1RQtAdcIdUbjS0ghadhK4bXgn0CVd4 ZOxzgbc0k99gdZ22UDQsoPdajBZjgN0qNQmXhg3TqYF2k9U83AeV+3qJaR0gHQVuJzEwD1MfyGh ktJLXwWH2ULBvTHpaxD0qgo2KplC6+XIyBRgkS2HNBo+otIFxeQWcNE/0Z5pJyYaOYQlg++uvqj /uFCosOUtX/2vjtl6/A8UN+/vooiCllA5PZvkAlxARi2zzJELLCZ+mHcROWTJ2ioQjNMO+bR8eS p8l0XUHx4S5Jb6iU6raPdVSGlrr8nGCgZVgMgehTlT0H7PKcOecQ1Kx0tfG87FU+kiuSAoZzCT/ HWGUdhAZIaD5mRl+udqrbU6vh1eY4y0CVc4zYHGXBI93vq+XxY0Bx/CyTX/VGle/B2KyeQs7ZeO Jv6iwmOc2o6EkDHXEjfXUYo9ZtSZXUwPwRH7rn4ClS X-Google-Smtp-Source: AGHT+IHvYk0qgLCWAw8Sgx9qW++HTlHw4kV515HTz3llv2WFNOaUQe5DqVAvbYOIl1LSj/IzLv6KzQ== X-Received: by 2002:a05:600c:3106:b0:47a:829a:ebb with SMTP id 5b1f17b1804b1-47d1957b115mr135775475e9.19.1766485151144; Tue, 23 Dec 2025 02:19:11 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:3497:ef51:d151:ea37:dee2]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-4324eaa08d9sm27694981f8f.30.2025.12.23.02.19.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 23 Dec 2025 02:19:10 -0800 (PST) Message-ID: Subject: Re: change ON CONFLICT UPDATE From: Laurenz Albe To: Bruce Momjian Cc: jian he , pgsql-docs@lists.postgresql.org Date: Tue, 23 Dec 2025 11:19:10 +0100 In-Reply-To: References: <02b43e62e62eecb352c4f64bb1bedfdec11bb3ac.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-12-22 at 19:42 -0500, Bruce Momjian wrote: > Agreed, patch applied, thanks. Thank you! Laurenz Albe