Updating a current column with an old column using triggers without exception StackOverflowError

[Paulo Destro]

I'm trying to update a column using the old row with triggers. But when I try updating the trigger loops infinitelly. I have the same exemple with updating timestamp on my github.

https://github.com/pddec/loop

[Evgenij Ryazanov]

Hello!

If you need to modify this row in your trigger, you must change values in the newRow array directly:

newRow[/* 0-based column index */] = OffsetDateTime.now();

[Paulo Destro]

0

You must write your trigger with AFTER SQL statement

CREATE TRIGGER update_timestamp_trigger AFTER UPDATE ON public.bill FOR EACH ROW CALL "loop.update.trigger.UpdateTimestamp";

I was using BEFORE