Realtime postgres_changes not working - missing action_filter column
realtimeHey everyone,
I'm having an issue with Realtime postgres_changes. When I try to subscribe to any table, I get this error:
ERROR 42703 (undefined_column) column "action_filter" of relation "subscription" does not exist
The realtime.subscription table is missing the action_filter column that the Realtime server expects.
What I've tried:
- Restarting the project
- Pausing and resuming the project
- ALTER TABLE to add the column (fails with "must be owner of table subscription")
It seems like an internal migration wasn't applied. Has anyone seen this before or know a workaround?
Thanks!
I'm having an issue with Realtime postgres_changes. When I try to subscribe to any table, I get this error:
ERROR 42703 (undefined_column) column "action_filter" of relation "subscription" does not exist
The realtime.subscription table is missing the action_filter column that the Realtime server expects.
What I've tried:
- Restarting the project
- Pausing and resuming the project
- ALTER TABLE to add the column (fails with "must be owner of table subscription")
It seems like an internal migration wasn't applied. Has anyone seen this before or know a workaround?
Thanks!
