Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit8545b28

Browse files
committed
Fix doc omission for MERGE into updatable views.
Commit5f2e179 missed one place in rules.sgml that should havementioned MERGE. Also, be more specific when saying that MERGE doesn'tsupport rules, since it does support SELECT rules.
1 parent0cf79a7 commit8545b28

File tree

1 file changed

+4
-2
lines changed

1 file changed

+4
-2
lines changed

‎doc/src/sgml/rules.sgml

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -859,7 +859,8 @@ SELECT t1.a, t2.b, t1.ctid FROM t1, t2 WHERE t1.a = t2.a;
859859
a view. These rules will rewrite the command, typically into a command
860860
that updates one or more tables, rather than views. That is the topic
861861
of <xref linkend="rules-update"/>. Note that this will not work with
862-
<command>MERGE</command>, which currently does not support rules.
862+
<command>MERGE</command>, which currently does not support rules on
863+
the target relation other than <command>SELECT</command> rules.
863864
</para>
864865

865866
<para>
@@ -873,7 +874,8 @@ SELECT t1.a, t2.b, t1.ctid FROM t1, t2 WHERE t1.a = t2.a;
873874

874875
<para>
875876
Automatic rewriting of an <command>INSERT</command>,
876-
<command>UPDATE</command>, or <command>DELETE</command> query on a
877+
<command>UPDATE</command>, <command>DELETE</command>, or
878+
<command>MERGE</command> query on a
877879
simple view is always tried last. Therefore, if a view has rules or
878880
triggers, they will override the default behavior of automatically
879881
updatable views.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp