can someone please help me with realtime? I feel like I'm losing my mind! I enable the table, which is in the public schema, for replication in the console, but nothing shows up on the client Sometimes, the enable will automatically be disabled without me doing anything However, it works fine on some tables I've made a couple weeks ago. I checked permissions for anon, authenticated, and service_role, and they all have full access. I'm really at a loss Please any help would be appreciated I also manually set replica to fulll

Hello @Paul! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

It might help to show your subscribe code. Do you get events if you turn RLS off? Is there a websocket open in the network tab? Do you get deletes? I’ve sometimes found the toggle on replication stuff to lag and if you click again it goes back off.

Paul (2022-04-12)

Turns out I for some reason put only a unique constraint and not a primary key constraint. I've modify my schema to have a primary key on the problematic table, and now it works!

Thread was archived by @Paul. Anyone can send a message to unarchive it.