Re: Order of update triggers - Mailing list pgsql-novice

From Rob Richardson
Subject Re: Order of update triggers
Date
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBDFA355F@RADCONWIN2K8PDC.radcon.local
Whole thread Raw
In response to Re: Order of update triggers  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Responses Re: Order of update triggers  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
List pgsql-novice
I have confirmed that in my case, the delete trigger is happening before the update trigger, presumably because it is
happeningin alphabetic order as was stated earlier.  But since the data being used by the update trigger comes from the
'new'object instead of from the current contents of the table, it does not matter that the underlying record may have
alreadybeen deleted.  (Of course, all triggers are fired within a single transaction, and inside a transaction, terms
like"before", "after" and "already" are effectively meaningless.  Right?) 

RobR


pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: Order of update triggers
Next
From: Angus
Date:
Subject: Install & Launch PgAdmin on CentOS 6.2 with PostgreSQL 8.4.9