Triggers disable realtime?

Hello all! I currently have a realtime table, messages, that my app subscribes to based on inserts.

This has been working, it stops working once I have added a trigger to that table. Any ideas?

When debugging I noticed that if I change the Enabled mode on my trigger to Origin, the trigger activates but realtime stops working. If I set it to Replica, realtime works but the trigger doesn't activate.
Setting it to Always makes the trigger work, but not realtime.

I also noticed that nothing is actually being inserted into the messages table when my trigger is set to Origin or Always. Which is why realtime isn't working, because there's nothing being inserted.

Anyone know why inserts stopping working after Triggers are enabled?
Was this page helpful?