Slony-I 2.2.4 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 8. Schema schemadoc | Fast Forward | Next |
Stores each change to be propagated to subscriber nodes
Structure of sl_log_1
integer
Origin node from which the change came
bigint
Transaction ID on the origin node
integer
The table ID (from sl_table.tab_id) that this log entry is to affect
bigint
The sequence number in which actions will be applied on replicas
text
The schema name of the table affected
text
The table name of the table affected
"char"
Replication action to take. U = Update, I = Insert, D = DELETE, T = TRUNCATE
integer
For cmdtype=U the number of updated columns in cmdargs
text[]
The data needed to perform the log action on the replica
Indexes on sl_log_1
log_origin, log_txid, log_actionseq