© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
28 replies
Daniel

Triggers disable realtime?

Hello all! I currently have a realtime table,
messages
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
Enabled mode
on my trigger to
Origin
Origin
, the trigger activates but realtime stops working. If I set it to
Replica
Replica
, realtime works but the trigger doesn't activate.
Setting it to
Always
Always
makes the trigger work, but not realtime.

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

Anyone know why inserts stopping working after Triggers are enabled?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Error RealtimeChannels - occurred when joining realtime table=eq id
SupabaseSSupabase / help-and-questions
4y ago
realtime
SupabaseSSupabase / help-and-questions
6mo ago
realtime
SupabaseSSupabase / help-and-questions
4y ago
Realtime
SupabaseSSupabase / help-and-questions
4y ago