Commite045565

committed

Improve docs on updatable views

Introduce the options before going into details, and add a link to theCREATE TRIGGER documentation.Author: David JohnstonReviewed-By: Anastasia LubennikovaDiscussion:https://postgr.es/m/CAKFQuwYLLRhheo0_Y4Jp=vJ_YDsz1KoRuTpX1A_bUxmHTmLe-A@mail.gmail.com

1 parentf1516ad commite045565Copy full SHA for e045565

File tree

-1

lines changed

-1

lines changed

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -797,6 +797,10 @@ SELECT t1.a, t2.b, t1.ctid FROM t1, t2 WHERE t1.a = t2.a;`
`797`	`797`	`relation points at a subquery range-table entry, which will not`
`798`	`798`	`work. There are several ways in which <productname>PostgreSQL</productname>`
`799`	`799`	`can support the appearance of updating a view, however.`
	`800`	`+ In order of user-experienced complexity those are: automatically substitute`
	`801`	`+ in the underlying table for the view, execute a user-defined trigger,`
	`802`	`+ or rewrite the query per a user-defined rule.`
	`803`	`+ These options are discussed below.`
`800`	`804`	`</para>`
`801`	`805`
`802`	`806`	`<para>`
`@@ -812,7 +816,8 @@ SELECT t1.a, t2.b, t1.ctid FROM t1, t2 WHERE t1.a = t2.a;`
`812`	`816`
`813`	`817`	`<para>`
`814`	`818`	`Alternatively, the operation may be handled by a user-provided`
`815`		`- <literal>INSTEAD OF</literal> trigger on the view.`
	`819`	`+ <literal>INSTEAD OF</literal> trigger on the view`
	`820`	`+ (see <xref linkend="sql-createtrigger"/>).`
`816`	`821`	`Rewriting works slightly differently`
`817`	`822`	`in this case. For <command>INSERT</command>, the rewriter does`
`818`	`823`	`nothing at all with the view, leaving it as the result relation`

Comments

(0)