UPDATE Trigger on multiple tables

From: Ferindo Middleton Jr <fmiddleton(at)verizon(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: UPDATE Trigger on multiple tables
Date: 2005-10-13 04:29:10
Message-ID: 434DE296.8060203@verizon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is it possible to have a single trigger on multiple tables
simultaneously? Example:

CREATE TRIGGER emp_cust_stamp BEFORE INSERT OR UPDATE ON employees, customers
FOR EACH ROW EXECUTE PROCEDURE last_updated_stamp();

I tried something like the above but get an error message at the comma. I tried using the keyword AND as well.
I couldn't find anything on this in the docs. I have many different tables in my databases which all have a
"last_updated" field and it seems less tedious to be able to enforce updating this trigger database-wide using
just one trigger. Is it possible?

Ferindo

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-10-13 04:39:10 Re: UPDATE Trigger on multiple tables
Previous Message Greg Stark 2005-10-13 04:24:55 Re: pg, mysql comparison with "group by" clause