1.3. Table: sl_event

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

ev_origin

integer PRIMARY KEY

The ID # (from sl_node.no_id) of the source node for this event

ev_seqno

bigint PRIMARY KEY

The ID # for the event

ev_timestamp

timestamp without time zone

When this event record was created

ev_minxid

xxid

Earliest XID on provider node for this event

ev_maxxid

xxid

Latest XID on provider node for this event

ev_xip

text

List of XIDs, in order, that are part of this event

ev_type

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 =

ev_data1

text

Data field containing an argument needed to process the event

ev_data2

text

Data field containing an argument needed to process the event

ev_data3

text

Data field containing an argument needed to process the event

ev_data4

text

Data field containing an argument needed to process the event

ev_data5

text

Data field containing an argument needed to process the event

ev_data6

text

Data field containing an argument needed to process the event

ev_data7

text

Data field containing an argument needed to process the event

ev_data8

text

Data field containing an argument needed to process the event