Holds information about replication events. After a period of time, Slony removes old confirmed events from both this table and the sl_confirm table.
Structure of sl_event
integer PRIMARY KEY
The ID # (from sl_node.no_id) of the source node for this event
bigint PRIMARY KEY
The ID # for the event
timestamp without time zone
When this event record was created
xxid
Earliest XID on provider node for this event
xxid
Latest XID on provider node for this event
text
List of XIDs, in order, that are part of this event
text
The type of event this record is for. SYNC = Synchronise STORE_NODE = ENABLE_NODE = DROP_NODE = STORE_PATH = DROP_PATH = STORE_LISTEN = DROP_LISTEN = STORE_SET = DROP_SET = MERGE_SET = SET_ADD_TABLE = SET_ADD_SEQUENCE = STORE_TRIGGER = DROP_TRIGGER = MOVE_SET = ACCEPT_SET = SET_DROP_TABLE = SET_DROP_SEQUENCE = SET_MOVE_TABLE = SET_MOVE_SEQUENCE = FAILOVER_SET = SUBSCRIBE_SET = ENABLE_SUBSCRIPTION = UNSUBSCRIBE_SET = DDL_SCRIPT = ADJUST_SEQ = RESET_CONFIG =
text
Data field containing an argument needed to process the event
text
Data field containing an argument needed to process the event
text
Data field containing an argument needed to process the event
text
Data field containing an argument needed to process the event
text
Data field containing an argument needed to process the event
text
Data field containing an argument needed to process the event
text
Data field containing an argument needed to process the event
text
Data field containing an argument needed to process the event