From 8e8d0f7e80d80c61b09346a84059457aeeeae548 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sat, 23 Feb 2013 00:28:33 -0500 Subject: [PATCH] doc: Add more compatibility information for triggers Louis-Claude Canon and Josh Kupershmidt --- doc/src/sgml/ref/create_trigger.sgml | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 0f87b1fc96..d9817e4a9e 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 The CREATE TRIGGER statement in PostgreSQL implements a subset of the - SQL standard. The following functionality is currently missing: + SQL standard. The following functionalities are currently + missing: @@ -500,6 +501,16 @@ CREATE TRIGGER view_insert + + + PostgreSQL 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 + OLD TABLE and NEW TABLE clauses in + the SQL standard. + + + PostgreSQL only allows the execution of a user-defined function for the triggered action. The standard -- 2.40.0