sql
create or replace function
basic_auth.check_role_exists() returns trigger as $$
begin
  if not exists (select 1 from pg_roles as r where r.rolname = new.role) then
    raise foreign_key_violation using message =
      'unknown database role: ' || new.role;
    return null;
  end if;
  return new;
end
$$ language plpgsql;

drop trigger if exists ensure_user_role_exists on basic_auth.users;
create constraint trigger ensure_user_role_exists
  after insert or update on basic_auth.users
  for each row
  execute procedure basic_auth.check_role_exists();

Bad Request

begin
  if ((SELECT raw_user_meta_data->>'provider_id' from auth.users WHERE auth.users.id = auth.uid())=new."DiscordID") then
    raise foreign_key_violation using message =
      'unknown discord id: ' || new."DiscordID";
    return null;
  end if;
  return new;
end

}
​​
code: "42501"
​​
details: null
​​
hint: null
​​
message: "permission denied for table users"
​​
<prototype>: Object { … }
​
status: 403
​
statusText: "Forbidden"

users

private

public

private.users

private.users