I've just started messing around in Supabase today, having had limited experience in SQL at Uni + having dabbled with it in previous jobs.

I found that I'd been updating triggers in the wrong way, simply by labling them v2,v3 and so on. Meaning that they were all trying to trigger my db function at the same time which caused my issue.

After deleting the older versions of the trigger I no longer received this error.