DEV Community

Discussion on: Database triggers not working

Collapse
 
mittalyashu profile image
Yashu Mittal • Edited

It's also possible that the trigger is executing, but not having the result you expect. You could create a debugging table with a single text field and have your trigger function insert a record into it, which would narrow the problem down to your update query construction.

Dam! That's a really good suggestion, why didn't I thought of that even though we use console.log() statements inside the codebase a lot. 😅


Also I will also look into logging and LISTEN/NOTIFY.