Postgres Pro
Downloads
Home   >   mailing lists

Re: should this be a trigger or a rule? - Mailing list pgsql-sql

From Tom Lane
Subject Re: should this be a trigger or a rule?
Date
Msg-id 11551.1008468260@sss.pgh.pa.us
Whole thread Raw
In response to should this be a trigger or a rule?  (marc@oscar.eng.cv.net (Marc Spitzer))
Responses Re: should this be a trigger or a rule?
List pgsql-sql
Tree view 
marc@oscar.eng.cv.net (Marc Spitzer) writes:
> I have 3 tables: pings, curr_state, ping_log and here is what I want
> to happen:
> when I insert a row into pings it checks to see if the ping was
> sucessful or not.

Anything that's most naturally described as driven by insert (or update
or delete) of individual rows is best done as a trigger, IMHO.
        regards, tom lane

pgsql-sql by date:

Previous
From: marc@oscar.eng.cv.net (Marc Spitzer)
Date:
Subject: should this be a trigger or a rule?
Next
From: Marc Spitzer
Date:
Subject: Re: should this be a trigger or a rule?