loading...

re: Database triggers not working VIEW POST

TOP OF THREAD FULL DISCUSSION
re: Set up logging and see if any errors show up. It's also possible that the trigger is executing, but not having the result you expect. You could cre...
 

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.

code of conduct - report abuse