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).
>
> 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
From d33e095ee9821d8cd55836c98c083502fee2e932 Mon Sep 17 00:00:00 2001
From: Laurenz Albe
Date: Wed, 26 Nov 2025 10:49:51 +0100
Subject: [PATCH v1] Doc: use ON CONFLICT DO UPDATE everywhere
Two places in the CREATE VIEW reference page used
ON CONFLICT UPDATE instead. Better be consistent.
Author: Laurenz Albe
Reported-By: jian he
Discussion: https://postgr.es/m/CACJufxEW1RRDD9ZWGcW_Np_Z9VGPE-YC7u0C6RcsEY8EKiTdBg%40mail.gmail.com
---
doc/src/sgml/ref/create_view.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml
index 7b6b750c6de..f8a4740608a 100644
--- a/doc/src/sgml/ref/create_view.sgml
+++ b/doc/src/sgml/ref/create_view.sgml
@@ -415,7 +415,7 @@ CREATE VIEW vista AS SELECT text 'Hello World' AS hello;
DELETE, or MERGE statement
on the view into the corresponding statement on the underlying base
relation. INSERT statements that have an ON
-CONFLICT UPDATE clause are fully supported.
+CONFLICT DO UPDATE clause are fully supported.
@@ -430,7 +430,7 @@ CREATE VIEW vista AS SELECT text 'Hello World' AS hello;
an INSERT or MERGE command can
potentially insert base-relation rows
that do not satisfy the WHERE condition and thus are not
-visible through the view (ON CONFLICT UPDATE may
+visible through the view (ON CONFLICT DO UPDATE may
similarly affect an existing row not visible through the view).
The CHECK OPTION may be used to prevent
INSERT, UPDATE, and
--
2.51.1
