Christopher B. Browne's Home Page
cbbrowne@acm.org

8.6. 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

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_1

sl_log_1_idx1

log_origin, log_txid, log_actionseq

Google
Contact me at cbbrowne@acm.org