| Slony-I 2.2.10 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 8. Schema schemadoc | Fast Forward | Next |
8.10. Table: sl_log_1
Stores each change to be propagated to subscriber nodes
Structure of sl_log_1
- 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
The sequence number in which actions will be applied on replicas
- log_tablenspname
text
The schema name of the table affected
- log_tablerelname
text
The table name of the table affected
- log_cmdtype
"char"
Replication action to take. U = Update, I = Insert, D = DELETE, T = TRUNCATE
- log_cmdupdncols
integer
For cmdtype=U the number of updated columns in cmdargs
- log_cmdargs
text[]
The data needed to perform the log action on the replica
Indexes on sl_log_1
- sl_log_1_idx1
log_origin, log_txid, log_actionseq