| Slony-I 2.2.10 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 8. Schema schemadoc | Fast Forward | Next |
8.11. 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
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. S = Script statement, s = Script complete
- 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_2
- sl_log_2_idx1
log_origin, log_txid, log_actionseq