Unable to subscribe to changes with given parameters
Having major issues with realtime updates on the client where it's not working properly when page first loads, then seems to start working.
Locally it works fine, so really not understanding what the issue is. Spent over a day trying to figure this out and making little progress.
This is not on the main
public
public
schema btw. But in the past that wasn't a problem at all. And now it does work, but seems to only semi work.
Full error:
{"ref":null,"event":"system","payload":{"message":"{:error, "Unable to subscribe to changes with given parameters. An exception happened so please check your connect parameters: [event: INSERT, filter: leagueId=eq.cmdfrtsst0000lg04lo9t873k, schema: epl25, table: Pick]. Exception: ERROR P0001 (raise_exception) invalid column for filter leagueId"}","status":"error","extension":"postgres_changes","channel":"supabase_realtime_pick"},"topic":"realtime:supabase_realtime_pick"}
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.