check_publication_coverage
Verifies that all expected tables are published and have correct REPLICA IDENTITY for UPDATE/DELETE, detecting silent data loss risks.
Instructions
Cross-check published tables against an expected set.
Judgment tool. Flags the two silent failures that lose data without erroring: (1) an expected table that no publication carries, and (2) a published table whose REPLICA IDENTITY can't support UPDATE/DELETE (REPLICA IDENTITY NOTHING, or DEFAULT with no primary key). Pass expected_tables as "schema.table" strings (bare names assume public). Run this on the PUBLISHER.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| expected_tables | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||