diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-02-25 22:24:00 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-02-25 22:24:00 +0000 |
| commit | d98039d8966dee1ce8a7dfc8687ebdbb4d77b3c6 (patch) | |
| tree | 2d1d46762cb2b3ec36066efce0ccc548022994c7 | |
| parent | 99419d36f2214458cc1f495b80be36da95291596 (diff) | |
| download | postgresql-d98039d8966dee1ce8a7dfc8687ebdbb4d77b3c6.tar.gz postgresql-d98039d8966dee1ce8a7dfc8687ebdbb4d77b3c6.zip | |
Document that after triggers that need to see changed rows should not be
marked stable.
| -rw-r--r-- | doc/src/sgml/ref/create_function.sgml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index ed5d7c5bda5..3d7eadcaf8b 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.90 2010/02/14 01:01:35 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.91 2010/02/25 22:24:00 momjian Exp $ --> <refentry id="SQL-CREATEFUNCTION"> @@ -289,7 +289,9 @@ CREATE [ OR REPLACE ] FUNCTION return the same result for the same argument values, but that its result could change across SQL statements. This is the appropriate selection for functions whose results depend on database lookups, - parameter variables (such as the current time zone), etc. Also note + parameter variables (such as the current time zone), etc. (It is + inappropriate for <literal>AFTER</> triggers that wish to + query rows modified by the current command.) Also note that the <function>current_timestamp</> family of functions qualify as stable, since their values do not change within a transaction. </para> |