Hi, I've defined a small trigger to increment a field each time the row is updated:
> CREATE TRIGGER inc_trigger BEFORE UPDATE ON Table FOR EACH ROW EXECUTE > PROCEDURE inc_function(); Works quite well, however the trigger is also fired if the table itself is modified. When deleting or inserting a single row, the trigger is executed for all rows contained in the table. Is this intetional, and if so, how can I get the behaviour to only execute the trigger when an update on the relation is performed? Thank you in advance, Clemens -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
