BEFORE UPDATE trigger also fires at insert? - Mailing list pgsql-general

From Clemens Eisserer
Subject BEFORE UPDATE trigger also fires at insert?
Date
Msg-id BANLkTikp_KHorR7AMYqUaAtcknX4svm3KA@mail.gmail.com
Whole thread Raw
Responses Re: BEFORE UPDATE trigger also fires at insert?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Iztok Stotl
Date:
Subject: Re: Help with database recovery ...
Next
From: Tom Lane
Date:
Subject: Re: BEFORE UPDATE trigger also fires at insert?