Fixed supabase trigger

In this video I am going to show you how to fix create supabase trigger from auth.users table.
sql:
- create trigger: create trigger trigger_name after insert on auth.users for each row execute function function_name();
- delete trigger: drop trigger if exists trigger_name on auth.users;
Support the channel : 🙏🌸
- donate 🌻: / dailywebcoding
Follow me: 👇
- Discord: / discord
- Github: github.com/Chensokheng

[@markbroomfield1818]

Thank you so much for the quick work around on this.
Works a treat, great channel and please keep up the amazing work. Thanks Mark

[@user-mu8xm5hf8h]

Thank you so much! I was stuck at making trigger on auth table. Your video helps me a lot!

[@edensaltzman1146]

Thanks for the workaround! Worked like a charm.

[@PiyushRaj-ij3dx]

Exactly what I needed! Thank you so much!

[@osmanakar2507]

thank you for the workaround 🙌 keep going with great the Supabase contents.

[@DailyWebCoding]

Thank you! Will do!

[@julienheng3880]

Thank you so much for your tutorial! it is really helpful!

[@mateussoares7599]

thanks man this helped me, straight to the point

[@therhythmatic]

This was clutch, thank you!

[@olekzaytsev3582]

Thanks mate! Very nice video, appreciate it.

[@tokenizatumarca]

Great content man! Super useful 🙏

[@DailyWebCoding]

Glad it was helpful!

[@iamchu]

Thanks for this!

[@HenriqueAntonioBarbosa]

Thank you so much!

[@valentinlorentejimenez2918]

Really appreciated!

[@chas.porter]

That solved it! Thank you!

[@vommir.]

Really nice, thank you.

[@filip_wojda]

thank you for this

[@sujitragav3962]

Thanks it really helped

[@surething3103]

Thanks a lot

[@makkhawanvoraboot1946]

thanks you alot broo

[@CC-xv7hf]

ty 💋

[@rajikkali2381]

Where is the create_user_on_signup function definition code??

[@abdulsamadayoade9439]

you have to create it, goto Database, click functions and create one, here is an example
begin
insert into public.user (id, name, email)
values (new.id, new.raw_user_meta_data ->> 'name', new.email);
return new;
end;

[@lukem829]

thanks a lot!

[@DailyWebCoding]

You're welcome!

[@reikoleci4689]

you the best

[@NagatoKamiPain]

where can I find function that you used?

[@keemkorn]

bro, just make it??

[@curious_cat505]

Great, but you only needed 2 minutes

[@ambicasupraja9651]

i am getting this error while sign up AuthApiError: duplicate key value violates unique constraint "user_pkey" as i am created trigger from sql editor

[@tarunfreestone6024]

I am stuck, supabase is not recognising the function i have created, is it security definer or invoker in advanced settings.

[@Raisingyourbloodpressure]

Why did they take it out in the first place? Does anyone know?

[@c0dingwithchris]

Could you please share the function that you use that the trigger is linked to?

[@DailyWebCoding]

dailyblog-demo.vercel.app/blog/1053fbb2-0018-4dd0-8f60-8282d7f9c402
You can check this and scroll to trigger function example. You can update this base on your application.

Good! One question: how do you pass the user_id to the function?

[@DailyWebCoding]

you can call auth.uid() This function will return the id of the user making the request.

@@DailyWebCoding thanks!

[@ThisIsChina-mu1ls]

@@DailyWebCoding new.id is not correct?

[@chrstnrcg]

can you share the function code?

[@kamil_supabase_enjoyer]

I had the same problem... Did you raised a ticket for this?

[@DailyWebCoding]

No I haven't yet

[@DailyWebCoding]

github.com/supabase/supabase/blob/master/studio/lib/constants/schemas.ts#L5 after digging to the code. They excluded it when create a trigger

[@kamil_supabase_enjoyer]

Thanks :) @@DailyWebCoding

[@EverythingWithKotlin]

@@DailyWebCoding can i see inside your function ? im getting error

[@patronovski]

i get permission denied when inserting row to the users table. To which role should i give the permission?

[@DailyWebCoding]

Make sure ur trigger function security is set to security definer.

[@patronovski]

@@DailyWebCoding thnx , it solved my problem. But isnt this a potential security issue? The function will be executed with the privileges of the user who created the function, rather than the user who calls the function. This means that the function may have elevated privileges, potentially bypassing some security restrictions.

[@DailyWebCoding]

@@patronovski I don't think it is a security issue. This is like a system function that will be trigger base on events and also this function can't be call beside the trigger event.

[@patronovski]

@@DailyWebCoding thats true, thanks again!

[@heugh_jazz]

you showed me the light, auto-like and auto-subscribe

[@XIIOSRS]

Keep getting this error: Error: AuthException(message: Database error saving new user, statusCode: 500)
Doesn't even create the auth user with this trigger on there, any ideas?

[@XIIOSRS]

UPDATE: My other reply just now doesn't work, here is the working one:
create function public.create_user()
returns trigger
language plpgsql
security definer set search_path = public
as $$
begin
insert into public.users (user_id, email, phone)
values (new.id, new.email, new.phone);
return new;
end;
$$;
create trigger on_auth_user_created
after insert on auth.users
for each row execute procedure public.create_user();

[@anthonyngooo]

at 3:40 you seemed to paste the same code and then it worked, do you have any idea why it worked the second time around?

[@DailyWebCoding]

Not really sure. maybe it is a bug

[@anthonyngooo]

Weird. Thanks for the response@@DailyWebCoding

[@leocaesar2]

hmm i cant even create the function
Failed to create function: failed to create pg.functions: syntax error at end of input

[@yasminelmahdi2003]

create trigger "trigger_name"
after insert on "table_name" for each row
execute procedure trigger_function();
try using this 'procedure' instead of 'function'

[@rajikkali2381]

I am stuck here too. He never shows the function definition, which I think we need?

[@yasminelmahdi2003]

@@rajikkali2381 try to write what I wrote above in SQL editor it should work fine

[@maybe_omuamua]

can u give me trigger plzzzzzzzzzzzzzz

[@DailyWebCoding]

It is in the description xD

[@rajikkali2381]

​@@DailyWebCoding the function code is never shown and is NOT in the description. For SQL noobs like myself, this makes your video useless.

[@DailyWebCoding]

@@rajikkali2381 it is useful for someone who know how to create a function

[@michaeldeveloper831]

Thank you so much!