From 7ac5727659f20ec20779127c5b0dbc3ae0fa93a9 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 16 Dec 2008 03:12:08 +0000 Subject: [PATCH] Fix wording of section comparing triggers and rules; old wording as confusing. --- doc/src/sgml/rules.sgml | 12 ++++-------- 1 file changed, 4 insertions(+), 8 deletions(-) diff --git a/doc/src/sgml/rules.sgml b/doc/src/sgml/rules.sgml index 8b4bee7c0a..cd55ba2ea8 100644 --- a/doc/src/sgml/rules.sgml +++ b/doc/src/sgml/rules.sgml @@ -1,4 +1,4 @@ - + The Rule System @@ -1869,13 +1869,9 @@ GRANT SELECT ON phone_number TO secretary; - On the other hand, a trigger that is fired on - INSERT on a view can do the same as a rule: put - the data somewhere else and suppress the insert in the view. But - it cannot do the same thing on UPDATE or - DELETE, because there is no real data in the - view relation that could be scanned, and thus the trigger would - never get called. Only a rule will help. + On the other hand, a trigger cannot be created on views because + there is no real data in a view relation; however INSERT, UPDATE, + and DELETE rules can be created on views. -- 2.11.0