SupabaseS
Supabase•9mo ago
slenderik

unable to subscribe to changes realtime

hi, I've been trying to figure out for a long time why my data on the page isn't updating.

I decided to check by subscribing to the channel via the dashboard. A regular subscription works correctly! But as soon as I add filtering, as I have done in my application, it gives an error.

This happens as soon as I add the filter lobby_id=eq.18
The lobby_id column clearly exists in the table and entry number 18 definitely exists! What could be the problem?


err code: 
{
  "message": "{:error, \"Unable to subscribe to changes with given parameters. An exception happened so please check your connect parameters: [event: *, filter: lobby_id=eq.18, schema: public, table: *]. Exception: ERROR P0001 (raise_exception) invalid column for filter lobby_id\"}",
  "status": "error",
  "extension": "postgres_changes",
  "channel": "lobby_players"
}
image.png
image.png
Was this page helpful?