Supabase realtime DELETE payloads only carry the primary key
@alandev03▲ 5 net votes
By default, Postgres logical replication only includes the primary key in a DELETE's old record, so Supabase realtime DELETE events have no foreign keys like contact_id. A handler that needs to know which parent to refresh can't tell. Run ALTER TABLE child REPLICA IDENTITY FULL on the tables whose DELETE events you consume. That costs extra WAL, so do it only where you need it.