CHANNEL_ERROR error: mismatch between server and client bindings for postgres changes

realtime

Having issues with Realtime postgres_changes - "mismatch between server and client bindings"

I'm getting this error when subscribing to a notifications table:
CHANNEL_ERROR error: mismatch between server and client bindings for postgres changes

Code:

const channel = supabase
  .channel(

const channel = supabase
  .channel(

notifications:${uid}

)
  .on('postgres_changes', { event: '*', schema: 'public', table: 'notifications' }, (payload) => {
    console.log('event:', payload);
  })
  .subscribe((status, err) => {
    console.log(status, err?.message);
  });

)
  .on('postgres_changes', { event: '*', schema: 'public', table: 'notifications' }, (payload) => {
    console.log('event:', payload);
  })
  .subscribe((status, err) => {
    console.log(status, err?.message);
  });

What I've verified:
Table is in the supabase_realtime publication (confirmed via SELECT * FROM pg_publication_tables)
Tried dropping and re-adding table to publication
Toggled Realtime on/off in dashboard
RLS is enabled with proper policies
Other tables (goals, tasks, comments) work fine with identical pattern
The weird thing is websocket messages briefly show "Subscribed to PostgreSQL" with status "ok", then immediately get a phx_close event. Using hosted Supabase, supabase-js latest. Any ideas?

CHANNEL_ERROR error: mismatch between server and client bindings for postgres changes

realtime

const channel = supabase
  .channel(

const channel = supabase
  .channel(

notifications:${uid}

)
  .on('postgres_changes', { event: '*', schema: 'public', table: 'notifications' }, (payload) => {
    console.log('event:', payload);
  })
  .subscribe((status, err) => {
    console.log(status, err?.message);
  });

)
  .on('postgres_changes', { event: '*', schema: 'public', table: 'notifications' }, (payload) => {
    console.log('event:', payload);
  })
  .subscribe((status, err) => {
    console.log(status, err?.message);
  });

CHANNEL_ERROR error: mismatch between server and client bindings for postgres changes

Similar Threads

CHANNEL_ERROR error: mismatch between server and client bindings for postgres changes

Similar Threads

Similar Threads

Similar Threads