diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2013-02-23 00:28:33 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2013-02-23 00:28:33 -0500 |
| commit | 8e8d0f7e80d80c61b09346a84059457aeeeae548 (patch) | |
| tree | d390e5413c6d7d148148768e2b73585b339fe39f /doc/src | |
| parent | 4f362926692631a67cd76b747f92389c8f63478e (diff) | |
| download | postgresql-8e8d0f7e80d80c61b09346a84059457aeeeae548.tar.gz postgresql-8e8d0f7e80d80c61b09346a84059457aeeeae548.zip | |
doc: Add more compatibility information for triggers
Louis-Claude Canon and Josh Kupershmidt
Diffstat (limited to 'doc/src')
| -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 |