0 <https://stackoverflow.com/posts/78234139/timeline>
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 Em quarta-feira, 27 de março de 2024 às 13:45:28 UTC-3, Paulo Destro escreveu: > 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.[image: IMG-20240327-WA0000.jpg] > > https://github.com/pddec/loop > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/e0e20508-2d27-4755-9f4c-901a6fc9c182n%40googlegroups.com.
