thing-permission-rls-trigger.sql

create or replace function insert_permission()
  returns trigger
  as $$
begin
  insert into permissions (item_id, user_or_group_id, role) values (
    new.id,
    current_setting('user_id')::uuid[]
  );
  return new;
end
$$ language plpgsql;

create trigger insert_permission_trigger
after insert
on things
for each row
execute procedure insert_permission();