I added a trigger to the auth.users table on inse...
# sqlj
Jaeden
10/07/2021, 12:52 PMI added a trigger to the auth.users table on insert. But author_id is still empty whilst it should contain the
id Copy code
-- create function for adding user to default watchlist
CREATE OR REPLACE FUNCTION give_user_default_watchlist() RETURNS TRIGGER as
$$
BEGIN
insert into public.watchlists(author_id) VALUES (new.id);
return new;
END
$$ language plpgsql security definer;
--Use the function when auth.users gets an insert
drop trigger if exists default_user_watchlist on auth.users;
create trigger default_user_watchlist after insert on auth.users execute procedure give_user_default_watchlist();j
jason-lynx
10/08/2021, 11:03 AMif you're trying to insert a new row, then your trigger function should require the other columns to be specified as well right?
jason-lynx
10/08/2021, 11:03 AMunless you've set a default for every other column?
j
Jaeden
10/08/2021, 1:06 PMThis got fixed @User . There was a
for eachJaeden
10/08/2021, 1:06 PM Copy code
-- create function for adding user to default watchlist
CREATE OR REPLACE FUNCTION give_user_default_watchlist() RETURNS TRIGGER as
$$
BEGIN
insert into public.watchlists (author_id) VALUES (new.id);
return new;
END;
$$ language plpgsql security definer;
--Use the function when auth.users gets an insert
drop trigger if exists default_user_watchlist on auth.users;
create trigger default_user_watchlist after insert on auth.users for each row execute function give_user_default_watchlist();Jaeden
10/08/2021, 1:06 PMand that didn't work
Jaeden
10/08/2021, 1:06 PMthanks for your help, I appreciate your time