Hi! I'm trying to figure out why running something like

sql
create or replace trigger on_user_update
before update on public.profiles for each row execute procedure handle_user_update;

in the cloud's sql editor returns

syntax error at or near "trigger"

but works fine if I omit the replace attempt ? Am I not doing it properly, from my understanding supabase runs Pg14.1 which should support

create or replace trigger ...

.

Hello @Embm! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Are you on a newer instance since Superbase announce 14 support?

Boiodry (2022-04-25)

Does not work on my 14.1 cloud version either.