Commit8e8d0f7

committed

doc: Add more compatibility information for triggers

Louis-Claude Canon and Josh Kupershmidt

1 parent4f36292 commit8e8d0f7Copy full SHA for 8e8d0f7

File tree

+12

-1

lines changed

+12

-1

lines changed

Lines changed: 12 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -484,7 +484,8 @@ CREATE TRIGGER view_insert`
`484`	`484`	`<para>`
`485`	`485`	`The <command>CREATE TRIGGER</command> statement in`
`486`	`486`	`<productname>PostgreSQL</productname> implements a subset of the`
`487`		`- <acronym>SQL</> standard. The following functionality is currently missing:`
	`487`	`+ <acronym>SQL</> standard. The following functionalities are currently`
	`488`	`+ missing:`
`488`	`489`
`489`	`490`	`<itemizedlist>`
`490`	`491`	`<listitem>`
`@@ -500,6 +501,16 @@ CREATE TRIGGER view_insert`
`500`	`501`	`</para>`
`501`	`502`	`</listitem>`
`502`	`503`
	`504`	`+ <listitem>`
	`505`	`+ <para>`
	`506`	`+ <productname>PostgreSQL</productname> does not allow the old and new`
	`507`	`+ tables to be referenced in statement-level triggers, i.e., the tables`
	`508`	`+ that contain all the old and/or new rows, which are referred to by the`
	`509`	`+ <literal>OLD TABLE</literal> and <literal>NEW TABLE</literal> clauses in`
	`510`	`+ the <acronym>SQL</> standard.`
	`511`	`+ </para>`
	`512`	`+ </listitem>`
	`513`	`+`
`503`	`514`	`<listitem>`
`504`	`515`	`<para><productname>PostgreSQL</productname> only allows the execution`
`505`	`516`	`of a user-defined function for the triggered action. The standard`

Comments

(0)