SupabaseS
Supabaseβ€’6d ago
π•Ώπ–Šπ–ˆπ–π–“π–”

Problem with RealTime

Hello everyone, I recently discovered Supabase. The client and admin configuration is working perfectly and the queries are going through. However, when I try to set up real-time event listeners on a database table, I encounter problems when subscribing to it.

The error returned by the subscription debugger is always the same:
subscribed: CLOSED & subscribed CHANNEL_ERROR Error: mismatch between server and client bindings for postgres changes

I've been searching for why it's failing, but apparently, it's not due to RLS (Row Level Security), which is configured to allow all users, even unconnected ones, to read and insert data (This is just for testing). Real-time is also correctly enabled on this table. What I don't understand is that the code seems correct, but it refuses to subscribe to any table with real-time enabled, always returning the same error.

  • Minimal code example for testing:
    supabase
        .channel("test")
        .on(
          "postgres_changes",
          { event: "*", schema: "public", table: "test"},
          (payload) => {
            console.log(payload);
          }
        )
        .subscribe((status, err) => {
          console.log("subscribed", status, err);
          console.log("Error:", err);
        });
  • Version used: $2.87.1$
If you can help me understand this, I sincerely thank you!
Was this page helpful?