Trigger not working or function not firing—RLS?

So I have this function that, when a

player

player

joins a game, the

players_conf

players_conf

(confirmed) column in the

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;

Screen_Shot_2022-11-23_at_10.52.17_AM.png

Supabase•4y ago•

18 replies

Smardrengr

Trigger not working or function not firing—RLS?

So I have this function that, when a

player

player

joins a game, the

players_conf

players_conf

(confirmed) column in the

games

games

 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;

Trigger not working or function not firing—RLS?

Similar Threads

Trigger not working or function not firing—RLS?

Similar Threads

Similar Threads

Similar Threads