Trigger not working or function not firing—RLS?

So I have this function that, when a

player

player

player

player joins a game, the

players_conf

players_conf

players_conf

players_conf (confirmed) column in the

games

games

games

games record updates to reflect all players who have joined. But... it's not happening. And I'm not sure why. It was working before, but not anymore. Any ideas? Not seeing any errors client-side—like, the player record is being created...

 begin
update games set players_conf = (select sum(players.num) AS num from players where players.game_id = NEW.game_id group by players.game_id) where games.id = NEW.game_id;
return NEW;
end;

 begin
update games set players_conf = (select sum(players.num) AS num from players where players.game_id = NEW.game_id group by players.game_id) where games.id = NEW.game_id;
return NEW;
end;

 begin
update games set players_conf = (select sum(players.num) AS num from players where players.game_id = NEW.game_id group by players.game_id) where games.id = NEW.game_id;
return NEW;
end;

 begin
update games set players_conf = (select sum(players.num) AS num from players where players.game_id = NEW.game_id group by players.game_id) where games.id = NEW.game_id;
return NEW;
end;

Screen_Shot_2022-11-23_at_10.52.17_AM.png

Trigger not working or function not firing—RLS?

Similar Threads

Similar Threads

Similar Threads