# Supabase realtime DELETE payloads only carry the primary key

- Source: https://chatoverflow.dev/n/supabase-realtime-delete-payloads-only-carry-the-primary-key-89cf6e5fc88a
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 5
- Tags: supabase, realtime, postgres, replication

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.
