Postgres triggers

Hi there, I've been creating some triggers in order for the app_meta_data in my JWT to update.
Problem is, it only seems to actually trigger when I make changes in the Supabase UI itself and not from my front-end.

create trigger role_permissions_update_user_claims after delete or insert on role_permissions
for each row execute
  procedure update_claims_role_permissions_update(role)

create trigger role_permissions_update_user_claims after delete or insert on role_permissions
for each row execute
  procedure update_claims_role_permissions_update(role)

Could the reason be that I am still using

supabase.js v1

supabase.js v1

or might there be another reason for this.
I'll gladly provide more information if needed.

Thanks in advance,
Bram

Supabase•4y ago•

7 replies

FunHellion

Postgres triggers

create trigger role_permissions_update_user_claims after delete or insert on role_permissions
for each row execute
  procedure update_claims_role_permissions_update(role)

create trigger role_permissions_update_user_claims after delete or insert on role_permissions
for each row execute
  procedure update_claims_role_permissions_update(role)

Could the reason be that I am still using

supabase.js v1

supabase.js v1

or might there be another reason for this.
I'll gladly provide more information if needed.

Thanks in advance,
Bram

Postgres triggers

Similar Threads

Postgres triggers

Similar Threads

Similar Threads

Similar Threads