Sets the readable or writable status of an instance node.
An instance node is normally readable and writable. When an instance node is set as non-readable it becomes unavailable for query. When an instance node is set as non-writable it becomes unavailable to agents for injecting new data.
Available in a network database and requires the star$network role.
Parameters:
| Name | Optional | Type | Description |
| node$ | Mandatory | Text | Name of the node to have its status set |
| readable$ | Mandatory | Boolean | Indicates if node is readable |
| writable$ | Mandatory | Boolean | Indicates if node is writable |
Examples:
SELECT set_node('mynode',false,false); -- sets node 'mynode' as non-readable and writable.
SELECT set_node('mynode',false,true); -- sets node 'mynode' as non-readable.
Tips:
- The star$nodes view lists existing nodes in the network
Comments
Article is closed for comments.