Trigger that is only executed once at the end of a transaction

Viewed 18

How can you program a trigger in PostgreSQL that is only called once at the end of a transaction as soon as a table x has been changed for which the trigger was defined? So the trigger should not fire for every row, nor for every statement, but only once, as soon as all statements of a transaction have been executed.

(The background is, I would like to save a time stamp for some tables when they were last changed.)

0 Answers
Related