PostgreSQL: During DDL Replication
The Extract behaves as follows when the extract is in running or in stopped state during DDL Replication:
- If the columns are added when Extract is in stopped state, Extract processes newer change records (after the DDL change). It reports a one-time warning while processing old change records (prior to DDL change) and ignores the missing columns
-
If the columns are added when Extract is in running state, Extract processes older change records (prior to DDL change) but it abends when it encounters new change records (after the DDL change), with the newly added columns.
-
If the columns are removed when Extract is in stopped state, Extract processes only the columns that are received in the older change records by returning a one-time warning and ignores the extra columns.
-
If the columns are removed when Extract is in running state, Extract processes only the columns that are received in the change records by returning a one-time warning for the missing columns.
-
Extract processes the columns for which it has the metadata and ignores any extra columns received from the transaction log.