Slony-I 2.0.8 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 6. Schema schemadoc | Fast Forward | Next |
6.7. Table: sl_log_2
Stores each change to be propagated to subscriber nodes
Structure of sl_log_2
- log_origin
integer
Origin node from which the change came
- log_txid
bigint
Transaction ID on the origin node
- log_tableid
integer
The table ID (from sl_table.tab_id) that this log entry is to affect
- log_actionseq
bigint
- log_cmdtype
character(1)
Replication action to take. U = Update, I = Insert, D = DELETE
- log_cmddata
text
The data needed to perform the log action
Indexes on sl_log_2
- sl_log_2_idx1
log_origin, log_txid, log_actionseq