remove_reorder_policy()
Remove a reorder policy from a hypertable
Since 1.2.0
Remove a policy to reorder a particular hypertable.
Samples
Section titled “Samples”SELECT remove_reorder_policy('conditions', if_exists => true);removes the existing reorder policy for the conditions table if it exists.
Arguments
Section titled “Arguments”The syntax is:
SELECT remove_reorder_policy( hypertable = '<hypertable_name>', if_exists = true | false);| Name | Type | Default | Required | Description |
|---|---|---|---|---|
hypertable | REGCLASS | - | ✔ | Name of the hypertable from which to remove the policy. |
if_exists | BOOLEAN | FALSE | ✖ | Set to true to avoid throwing an error if the reorder_policy does not exist. A notice is issued instead. |
Returns
Section titled “Returns”This function returns void.