Forcing a trigger to run

From: Michael A Nachbaur <mike(at)nachbaur(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Forcing a trigger to run
Date: 2003-08-28 22:47:51
Message-ID: 200308281547.51658.mike@nachbaur.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello all,

I have several tables with triggers on them that all collectively manage a
series of summary tables. In any case, there are instances where changes to
a given table may cause another trigger to need to be run.

What I have is an EmailAddress table, with other tables describing aliases,
forwards, etc. So, if an email address is changed, the triggers on it's
aliases should be run to see if they are still valid.

I was thinking of putting something in the trigger for EmailAddress that would
effectively say:

UPDATE EmailAddressAlias SET ID=ID WHERE EmailAddressID=CurrID;

but that seems like a big hack. While this would force the alias' triggers to
run, it seems to me that there should be a cleaner way of doing this.

Suggestions, anyone?

--
/* Michael A. Nachbaur <mike(at)nachbaur(dot)com>
* http://nachbaur.com/pgpkey.asc
*/

`I am so amazingly cool you could keep a side of meat in me for a month. I am
so hip I have difficulty seeing over my pelvis.'

Browse pgsql-sql by date

  From Date Subject
Next Message Joseph Shraibman 2003-08-28 23:52:25 Re: How to join from two tables at once?
Previous Message Chris Anderson 2003-08-28 21:48:51 BEFORE UPDATE Triggers