"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
Last activity: May 22, 2022, 10:02 PM