Sample Header Ad - 728x90

"Function unaccent(text) does not exist" in update trigger

4 votes
1 answer
5143 views
I've created a trigger for table x1 to update a column y with the expression to_tsvector(unaccent(x1.col1 || ' ' || x2.col1)). This trigger function throws: > function unaccent(text) does not exist Why would this function not exist when a trigger is called, but exist when executed manually? I'm using Supabase to manage this database.
Asked by Alb (142 rep)
May 22, 2022, 04:12 PM
Last activity: May 22, 2022, 10:02 PM