NEW variable is null in a trigger function.

[GaryAustin1]

This is a copy of a troubleshooting article on Supabase's docs site. It may be missing some details from the original. View the original article.

When you create a function and call it from a trigger the NEW variable is only passed in if the trigger is on ROW operations

The UI currently defaults to STATEMENT which will not provide NEW or OLD variables to the function.

Also in SQL (reference: https://www.postgresql.org/docs/current/sql-createtrigger.html)