Database function as Trigger has null values for new.column
Hi All
I have used Supabase database functions as triggers before and everything worked correctly.
Today while doing it again on a new project I am setting up a trigger with a database function and am trying to access the inserted column value using the new.column syntax.
I can confirm my function is triggered and I can even have update queries run successfully when using constants. However when I am trying to use the updated values using the new.column syntax my query doesn't do anything silently and throws no error either.
Can someone please help me out here? I am very much stuck.
I have used Supabase database functions as triggers before and everything worked correctly.
Today while doing it again on a new project I am setting up a trigger with a database function and am trying to access the inserted column value using the new.column syntax.
I can confirm my function is triggered and I can even have update queries run successfully when using constants. However when I am trying to use the updated values using the new.column syntax my query doesn't do anything silently and throws no error either.
Can someone please help me out here? I am very much stuck.
