👋 , I'm trying to encrypt a field when using a trigger, but I get an error when saving, any help? This works

create or replace function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, email)
  values (new.id, new.email);
  return new;
end;
$$ language plpgsql security definer;

This doesn't work - I get this error

{ message: 'Database error saving new user', status: 500 }

create or replace function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, email)
  values (new.id, pgp_sym_encrypt(new.email, 'KEY'));
  return new;
end;
$$ language plpgsql security definer;

The only difference is

pgp_sym_encrypt(new.email, 'KEY')

this should be because

pgp_sym_encrypt

returns

bytea

instead of text

Ahh... it still didn't work for me @User but that is a great thought. When I do insert it with SQL however, everything works as expected which is odd..

INSERT INTO users (email)
VALUES (pgp_sym_encrypt('test@email.com', 'KEY'));