DEV Community

Discussion on: Database triggers not working

Collapse
 
dmfay profile image
Dian Fay
  1. Set up logging and see if any errors show up.
  2. 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. There's also LISTEN/NOTIFY if you can't or don't want to create more tables.
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.