Triggers and rules

From: "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Triggers and rules
Date: 2001-09-28 20:07:54
Message-ID: 000f01c14859$44012720$6e646464@New6.Travel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A table has TRIGGER BEFORE UPDATE, TRIGGER AFTER UPDATE and RULE ON UPDATE.
1. What is the order these three are executed?
2. Are the actions of one of them visible to the following ones, or they all
refer strictly to the record before update? E.g.: If the TRIGGER BEFORE
UPDATE changes a value in the new record, is this visible to the RULE and to
the TRIGGER AFTER UPDATE?
Thank you all.

Browse pgsql-general by date

  From Date Subject
Next Message Mihai Gheorghiu 2001-09-28 20:24:53 String functions
Previous Message Arcady Genkin 2001-09-28 20:06:57 Re: Authenticating user `postgres'