Hi
CREATE TRIGGER associates trigger function on a table and it is not possible to give more than one table seperated by comas.
CREATE TRIGGER emp_cust_stamp BEFORE INSERT OR UPDATE ON customersFOR EACH ROW EXECUTE PROCEDURE last_updated_stamp();
CREATE TRIGGER emp_cust_stamp BEFORE INSER
Ferindo Middleton Jr <[EMAIL PROTECTED]> writes:
> 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();
No. You can use the
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 tri
