diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index 3df791a..a3a0eae 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -1670,11 +1670,10 @@ test_sub=# SELECT * FROM t1 ORDER BY id; The log format for logical replication conflicts is as follows: LOG: conflict detected on relation "schemaname.tablename": conflict=conflict_type -DETAIL: detailed explanation. - -Key (column_name, ...)=(column_value, ...) -; existing local tuple (column_name, ...)=(column_value, ...); remote tuple (column_name, ...)=(column_value, ...); replica identity {(column_name, ...)=(column_value, ...) | full (column_value, ...)}. +DETAIL: detailed_explanation. +Key (column_name, ...)=(column_value, ...); existing local tuple (column_name, ...)=(column_value, ...); remote tuple (column_name, ...)=(column_value, ...); replica identity {(column_name, ...)=(column_value, ...) | full (column_value, ...)}. + The log provides the following information: @@ -1683,28 +1682,34 @@ DETAIL: detailed explanation. - The name of the local relation involved in the conflict and the conflict - type (e.g., insert_exists, - update_exists). + schemaname.tablename + identifies the local relation involved in the conflict. + + + + + conflict_type is the type of conflict that occurred + (e.g., insert_exists, update_exists). + DETAIL - The origin, transaction ID, and commit timestamp of the transaction that - modified the existing local tuple, if available, are included in the - detailed explanation. + detailed_explanation includes + the origin, transaction ID, and commit timestamp of the transaction that + modified the existing local tuple, if available. - The key section includes the key values of the local + The Key section includes the key values of the local tuple that violated a unique constraint insert_exists or update_exists conflicts. @@ -1732,7 +1737,20 @@ DETAIL: detailed explanation. The replica identity section includes the replica identity key values that used to search for the existing local tuple to be updated or deleted. This may include the full tuple value if the local - relation is marked with REPLICA IDENTITY FULL. + relation is marked with + REPLICA IDENTITY FULL. + + + + + column_name is the column name. + These are optionally logged and, if present, are in the same order as the + corresponding column value. + + + + + column_value is the column value.