| Slony-I 2.2.10 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 8. Schema schemadoc | Fast Forward | Next |
8.22. Table: sl_subscribe
Holds a list of subscriptions on sets
Structure of sl_subscribe
- sub_set
integer PRIMARY KEY REFERENCES sl_set
ID # (from sl_set) of the set being subscribed to
- sub_provider
integer REFERENCES sl_path
ID# (from sl_node) of the node providing data
- sub_receiver
integer PRIMARY KEY REFERENCES sl_path
ID# (from sl_node) of the node receiving data from the provider
- sub_forward
boolean
Does this provider keep data in sl_log_1/sl_log_2 to allow it to be a provider for other nodes?
- sub_active
boolean
Has this subscription been activated? This is not set on the subscriber until AFTER the subscriber has received COPY data from the provider