Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-2307

Clarify expectations for replica identity and key-less tables

    XMLWordPrintable

    Details

      Description

      See https://debezium.io/documentation/reference/connectors/postgresql.html#postgresql-replica-identity

      As an example, the debezium postgres documentation states the following:

      DEFAULT - UPDATE and DELETE events will only contain the previous values for the primary key columns of a table, in case of UPDATE only the primary columns with changed values are present

      This is somewhat ambiguous in that for key-less tables, no update or delete event will be emitted. This is in-part due to a filter applied to both create, update, and delete relational messages, https://github.com/debezium/debezium/blob/master/debezium-core/src/main/java/io/debezium/relational/RelationalChangeRecordEmitter.java#L69.

      I think it would be better for users that we document the expected behavior for both if a primary key exists and does not exist for each replica identity.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              ccranfor Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: