| Slony-I 1.2.23 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 1. Schema schemadoc | Fast Forward | Next |
1.4. 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