From b2188575c59462c0fd23b63c92fb802206162e49 Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Tue, 18 Apr 2017 11:51:06 +0300 Subject: [PATCH] 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 --- doc/src/sgml/ref/create_trigger.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 24195b3849..c5f7c75838 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 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(); @@ -543,8 +543,8 @@ CREATE TRIGGER transfer_insert 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(); -- 2.40.0