diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2017-04-18 11:51:06 +0300 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2017-04-18 11:51:06 +0300 |
| commit | b2188575c59462c0fd23b63c92fb802206162e49 (patch) | |
| tree | ceb274cb981cf60b54ec053638d8b4ccb0c1d97e /doc/src | |
| parent | 8efd1e08f063892be13de085e5e2c0e802fadf55 (diff) | |
Fix example on creating a trigger with a transition table.
Yugo Nagata
Discussion: https://www.postgresql.org/message-id/20170417180921.3047f3b0.nagata@sraoss.co.jp
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_trigger.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 24195b3849d..c5f7c758381 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -531,8 +531,8 @@ CREATE TRIGGER view_insert <programlisting> CREATE TRIGGER transfer_insert AFTER INSERT ON transfer - FOR EACH STATEMENT REFERENCING NEW TABLE AS inserted + FOR EACH STATEMENT EXECUTE PROCEDURE check_transfer_balances_to_zero(); </programlisting> @@ -543,8 +543,8 @@ CREATE TRIGGER transfer_insert <programlisting> CREATE TRIGGER paired_items_update AFTER UPDATE ON paired_items - FOR EACH ROW REFERENCING NEW TABLE AS newtab OLD TABLE AS oldtab + FOR EACH ROW EXECUTE PROCEDURE check_matching_pairs(); </programlisting> </para> |