Postgres upgrade blocked by managed realtime schema objects
realtimeI’m blocked from upgrading Postgres because Supabase reports these issues:
realtime.messages — Move the table to your own schema
realtime.messages_pkey — Move the table to your own schema
realtime.messages_inserted_at_topic_index — Move the table to your own schema
realtime.topic — Move the function to your own schema
However, clicking “Manage” only opens Database > Tables filtered to schema=realtime. The realtime schema is marked as protected/read-only in Studio, so there is no action available to move these objects.
I also verified there are no custom realtime RLS policies: select schemaname, tablename, policyname, permissive, roles, cmd from pg_policies where schemaname = 'realtime' order by tablename, policyname;
Result: no rows returned.
This project only uses Postgres Changes publication setup for public tables, not custom realtime schema objects.
realtime.messages — Move the table to your own schema
realtime.messages_pkey — Move the table to your own schema
realtime.messages_inserted_at_topic_index — Move the table to your own schema
realtime.topic — Move the function to your own schema
However, clicking “Manage” only opens Database > Tables filtered to schema=realtime. The realtime schema is marked as protected/read-only in Studio, so there is no action available to move these objects.
I also verified there are no custom realtime RLS policies: select schemaname, tablename, policyname, permissive, roles, cmd from pg_policies where schemaname = 'realtime' order by tablename, policyname;
Result: no rows returned.
This project only uses Postgres Changes publication setup for public tables, not custom realtime schema objects.
