SHOW default_transaction_read_only returns on; pg_is_in_recovery() is false; writes fail with cannot execute INSERT in a read-only transaction.
pg_settings shows source=user. pg_db_role_setting indicates supabase_read_only_user has default_transaction_read_only=on.
Role/database resets had no effect; reserved role cannot be modified by us.
Can Supabase clear the read-only GUC / restore writer mode?
Need this urgently fixed up as I have live users
Ticket: SU-329798