# X_LIVE_REPLICA_IDENTITY

## Means

a replicated table has no replica identity

## Typical cause

an entity table with no primary key under `REPLICA IDENTITY DEFAULT`, or with `REPLICA IDENTITY NOTHING`: once published, Postgres refuses its `UPDATE` and `DELETE` and a change cannot be keyed. A table with a primary key is never named (22.1.0; until then every non-`FULL` table was, on every boot). Warned at preflight, never thrown

## Fix

`ALTER TABLE <t> REPLICA IDENTITY FULL;` or a primary key — one per table the warning names; rows already in the WAL keep the identity they were written with

[Realtime](/error-codes#realtime)
