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 1vOCCA-00E0tm-0J for pgsql-docs@arkaria.postgresql.org; Wed, 26 Nov 2025 09:52:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOCC8-00FU3v-23 for pgsql-docs@arkaria.postgresql.org; Wed, 26 Nov 2025 09:52:16 +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 1vOCC8-00FU3i-19 for pgsql-docs@lists.postgresql.org; Wed, 26 Nov 2025 09:52:16 +0000 Received: from mail-ed1-x529.google.com ([2a00:1450:4864:20::529]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vOCC6-001aFG-2K for pgsql-docs@lists.postgresql.org; Wed, 26 Nov 2025 09:52:16 +0000 Received: by mail-ed1-x529.google.com with SMTP id 4fb4d7f45d1cf-64088c6b309so10511344a12.0 for ; Wed, 26 Nov 2025 01:52:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1764150732; x=1764755532; darn=lists.postgresql.org; h=mime-version:user-agent:references:in-reply-to:date:to:from:subject :message-id:from:to:cc:subject:date:message-id:reply-to; bh=G5MYQTCbrm8lEb16P0u7V/4JJNXpY3Xi8tHUZvxFV4A=; b=lo6nLXdchBQEu5BW9/NnxBveoD1PGJ+kXdDpzbzaXXJPfLaG5IkZjX+A9GTMgcORvi FXo2I99ybXIo0+9GVrWgMSrAe9Ry54xv2yeZYZ7JcgK8m0X/iSJA7LV6mGgSLyKeDV81 tevCA4EzMeaxJ+ER0wXWDeV3PhtpCqPLdWXZnKUZap3uqhQfLC0014G5az7cXQgryrCl PEagbpdnwVP+qf30QyI4BtJR6IC/adhuahCixkFjV/iGs/90ZZaEnVrq3PlsukS859f0 FfNZ4FlGLdz3VjQjPko9XFWBO0aRu8YEx5+DWiErUq+Q/FvTUhR0CLWGnQ77gtlfWHvx okgA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764150732; x=1764755532; h=mime-version:user-agent:references:in-reply-to:date:to:from:subject :message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=G5MYQTCbrm8lEb16P0u7V/4JJNXpY3Xi8tHUZvxFV4A=; b=ElEcTZE925FwRWE4jlWIYK8ddyho5fd47uSQil/MYNuaMp3ja1AEfoe7PV4dqEyNaS mA5OEZpULQKFuIWFoplAs6a9yHANZ+SbvTkmZADJJRM8qyO4pH7VAyoqKVj1uFS85/EH 05208pwsIjXWIwQt43kChi/Wkh1f4X7vLP37+BWEcI729n8/gRi1fJLgvKfgMqFIqEsf CQODnFzzsD6yVG8YRG8THWmdZTVO+63sh9/MauewCLmO+dMfKZtwOXGCqEksEnk29OcY oSnMOCPIFWXr1BK+FEZ36Is/t/bHhq1Am2AMgqk1i5D+FTdnhzMuQw9top4h6LxNGqtd QBhg== X-Forwarded-Encrypted: i=1; AJvYcCU7qfubNI0Y8LT5oqquJrm+uvRYMzvgiu1H/gcsLGZaUeKxC56ZnxOr2GByJBFSlOM6KKatTNFIsnUw@lists.postgresql.org X-Gm-Message-State: AOJu0Yy+Dr9kzL5W6PuyPYkaSNtmXZ6siJ1jOMcwd0ZqHytTpTnktd4Y uW1luhjfxrdIqCIEN+wy0RfN5Pr4vASszGLzDofd75jMh9zZAnpH8N9bMIlwQhEj5nk= X-Gm-Gg: ASbGncu2b+fuK/O5roZv96jYwk5IvW8Bw9u88pp47+JiuNwJ83cl7fn5PMLiiWNTpzA QuDjof63Mf4MtONmK3Zxv53aHQNGkHpHFab8AqQRU3NQ637oUg6t0QQL0okHIz4OD6K3PYBUrmC dNx03U1rrcZQxYlfIcMwLQH/fmoJl2DfhOhJcjAProZER0876ApXHPOfVRKUqb+Bx8FcAW9R3oi rNNx4H4y5qNhqL8W/jlUns5ng91Oco9e55eJP6ZnN1WJXJmuJghBWdqWcqaei2coyzf8L2Iq6d6 61dF3Obpqbha3CTW/1WpDRYVIwdXtZbqA+Src7yWn5qBKNom5qRN9WskfoFhq+Fe+u2XYqjT4Ic et0eT3izdn2WrfMI6deNbUrlkffOGQ4kHh0EnE0fGCx6Lcw4/wI/JRUAPeFCB3GqhzoVc5fvUOd X75fNc/83Gl23odhPm9UYK5xaC1/w801VPhLuv X-Google-Smtp-Source: AGHT+IHDz47Np63MTbHDhHrqbt/YtPHNLMKAU7XZI43l1WAXX/Ly9euuC4acPAfq+PWc8Mcs/FvgIQ== X-Received: by 2002:a17:907:1b02:b0:b40:b54d:e687 with SMTP id a640c23a62f3a-b7671acc2d5mr2070053366b.47.1764150732467; Wed, 26 Nov 2025 01:52:12 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([41.66.99.31]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b765503a990sm1831411466b.63.2025.11.26.01.52.11 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Nov 2025 01:52:11 -0800 (PST) Message-ID: <02b43e62e62eecb352c4f64bb1bedfdec11bb3ac.camel@cybertec.at> Subject: Re: change ON CONFLICT UPDATE From: Laurenz Albe To: jian he , pgsql-docs@lists.postgresql.org Date: Wed, 26 Nov 2025 10:52:10 +0100 In-Reply-To: References: Content-Type: multipart/mixed; boundary="=-NShNItjWtOJzyrh3/kUI" 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 --=-NShNItjWtOJzyrh3/kUI Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, 2025-11-25 at 22:47 +0800, jian he wrote: > in doc/src/sgml/ref/create_view.sgml, > I want change two occurrences of > ON CONFLICT UPDATE > to > ON CONFLICT DO UPDATE > (between line 412 to line 439). >=20 > since other places using ON CONFLICT DO UPDATE. +1 It is not very important, but consistency is always good. Here is a patch for that. Yours, Laurenz Albe --=-NShNItjWtOJzyrh3/kUI Content-Disposition: attachment; filename="v1-0001-Doc-use-ON-CONFLICT-DO-UPDATE-everywhere.patch" Content-Type: text/x-patch; name="v1-0001-Doc-use-ON-CONFLICT-DO-UPDATE-everywhere.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSBkMzNlMDk1ZWU5ODIxZDhjZDU1ODM2Yzk4YzA4MzUwMmZlZTJlOTMyIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogV2VkLCAyNiBOb3YgMjAyNSAxMDo0OTo1MSArMDEwMApTdWJqZWN0OiBbUEFUQ0gg djFdIERvYzogdXNlIE9OIENPTkZMSUNUIERPIFVQREFURSBldmVyeXdoZXJlCgpUd28gcGxhY2Vz IGluIHRoZSBDUkVBVEUgVklFVyByZWZlcmVuY2UgcGFnZSB1c2VkCk9OIENPTkZMSUNUIFVQREFU RSBpbnN0ZWFkLiAgQmV0dGVyIGJlIGNvbnNpc3RlbnQuCgpBdXRob3I6IExhdXJlbnogQWxiZSA8 bGF1cmVuei5hbGJlQGN5YmVydGVjLmF0PgpSZXBvcnRlZC1CeTogamlhbiBoZSA8amlhbi51bml2 ZXJzYWxpdHlAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQ0p1 ZnhFVzFSUkREOVpXR2NXX05wX1o5VkdQRS1ZQzd1MEM2UmNzRVk4RUtpVGRCZyU0MG1haWwuZ21h aWwuY29tCi0tLQogZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdmlldy5zZ21sIHwgNCArKy0tCiAx IGZpbGUgY2hhbmdlZCwgMiBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdp dCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3ZpZXcuc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYv Y3JlYXRlX3ZpZXcuc2dtbAppbmRleCA3YjZiNzUwYzZkZS4uZjhhNDc0MDYwOGEgMTAwNjQ0Ci0t LSBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3ZpZXcuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwv cmVmL2NyZWF0ZV92aWV3LnNnbWwKQEAgLTQxNSw3ICs0MTUsNyBAQCBDUkVBVEUgVklFVyB2aXN0 YSBBUyBTRUxFQ1QgdGV4dCAnSGVsbG8gV29ybGQnIEFTIGhlbGxvOwogICAgIDxjb21tYW5kPkRF TEVURTwvY29tbWFuZD4sIG9yIDxjb21tYW5kPk1FUkdFPC9jb21tYW5kPiBzdGF0ZW1lbnQKICAg ICBvbiB0aGUgdmlldyBpbnRvIHRoZSBjb3JyZXNwb25kaW5nIHN0YXRlbWVudCBvbiB0aGUgdW5k ZXJseWluZyBiYXNlCiAgICAgcmVsYXRpb24uICA8Y29tbWFuZD5JTlNFUlQ8L2NvbW1hbmQ+IHN0 YXRlbWVudHMgdGhhdCBoYXZlIGFuIDxsaXRlcmFsPk9OCi0gICAgQ09ORkxJQ1QgVVBEQVRFPC9s aXRlcmFsPiBjbGF1c2UgYXJlIGZ1bGx5IHN1cHBvcnRlZC4KKyAgICBDT05GTElDVCBETyBVUERB VEU8L2xpdGVyYWw+IGNsYXVzZSBhcmUgZnVsbHkgc3VwcG9ydGVkLgogICAgPC9wYXJhPgogCiAg ICA8cGFyYT4KQEAgLTQzMCw3ICs0MzAsNyBAQCBDUkVBVEUgVklFVyB2aXN0YSBBUyBTRUxFQ1Qg dGV4dCAnSGVsbG8gV29ybGQnIEFTIGhlbGxvOwogICAgIGFuIDxjb21tYW5kPklOU0VSVDwvY29t bWFuZD4gb3IgPGNvbW1hbmQ+TUVSR0U8L2NvbW1hbmQ+IGNvbW1hbmQgY2FuCiAgICAgcG90ZW50 aWFsbHkgaW5zZXJ0IGJhc2UtcmVsYXRpb24gcm93cwogICAgIHRoYXQgZG8gbm90IHNhdGlzZnkg dGhlIDxsaXRlcmFsPldIRVJFPC9saXRlcmFsPiBjb25kaXRpb24gYW5kIHRodXMgYXJlIG5vdAot ICAgIHZpc2libGUgdGhyb3VnaCB0aGUgdmlldyAoPGxpdGVyYWw+T04gQ09ORkxJQ1QgVVBEQVRF PC9saXRlcmFsPiBtYXkKKyAgICB2aXNpYmxlIHRocm91Z2ggdGhlIHZpZXcgKDxsaXRlcmFsPk9O IENPTkZMSUNUIERPIFVQREFURTwvbGl0ZXJhbD4gbWF5CiAgICAgc2ltaWxhcmx5IGFmZmVjdCBh biBleGlzdGluZyByb3cgbm90IHZpc2libGUgdGhyb3VnaCB0aGUgdmlldykuCiAgICAgVGhlIDxs aXRlcmFsPkNIRUNLIE9QVElPTjwvbGl0ZXJhbD4gbWF5IGJlIHVzZWQgdG8gcHJldmVudAogICAg IDxjb21tYW5kPklOU0VSVDwvY29tbWFuZD4sIDxjb21tYW5kPlVQREFURTwvY29tbWFuZD4sIGFu ZAotLSAKMi41MS4xCgo= --=-NShNItjWtOJzyrh3/kUI--