Date: Thu, 13 Oct 2005 00:29:10 -0400
From: Ferindo Middleton Jr <fmiddleton@verizon.net>
Subject: UPDATE Trigger on multiple tables
To: pgsql-sql@postgresql.org
Reply-To: fmiddleton@verizon.net
Message-id: <434DE296.8060203@verizon.net>
Organization: Sleek Collar
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7bit
User-Agent: Thunderbird 1.4 (Windows/20050908)

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