diff options
| -rw-r--r-- | doc/src/sgml/ref/create_trigger.sgml | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 0f87b1fc96d..d9817e4a9e1 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -484,7 +484,8 @@ CREATE TRIGGER view_insert <para> The <command>CREATE TRIGGER</command> statement in <productname>PostgreSQL</productname> implements a subset of the - <acronym>SQL</> standard. The following functionality is currently missing: + <acronym>SQL</> standard. The following functionalities are currently + missing: <itemizedlist> <listitem> @@ -501,6 +502,16 @@ CREATE TRIGGER view_insert </listitem> <listitem> + <para> + <productname>PostgreSQL</productname> does not allow the old and new + tables to be referenced in statement-level triggers, i.e., the tables + that contain all the old and/or new rows, which are referred to by the + <literal>OLD TABLE</literal> and <literal>NEW TABLE</literal> clauses in + the <acronym>SQL</> standard. + </para> + </listitem> + + <listitem> <para><productname>PostgreSQL</productname> only allows the execution of a user-defined function for the triggered action. The standard allows the execution of a number of other SQL commands, such as |