security definer

function_logs

create or replace function public.activate_confirmed_user()
returns trigger as $$
begin
  if (old.confirmed_at != new.confirmed_at) then
  --update user to active
    update public.users u
    set activated = true
    where u.id = new.id;
  --update user tryggers to active
    update public.tryggers 
    set active = true
    where user_id = new.id;
    commit;
  end if;
  return new;
end;
$$ language plpgsql security definer;

create trigger on_auth_user_confirmed
  after update on auth.users
  for each row execute procedure public.activate_confirmed_user();

raise log 'I am here'

old.confirmed_at

is distinct from

sql
select null != 'new confirmed at', null is distinct from 'new confirmed at'