Skip to content

remove_reorder_policy()

Remove a reorder policy from a hypertable

Since 1.2.0

Remove a policy to reorder a particular hypertable.

SELECT remove_reorder_policy('conditions', if_exists => true);

removes the existing reorder policy for the conditions table if it exists.

The syntax is:

SELECT remove_reorder_policy(
hypertable = '<hypertable_name>',
if_exists = true | false
);
NameTypeDefaultRequiredDescription
hypertableREGCLASS-Name of the hypertable from which to remove the policy.
if_existsBOOLEANFALSESet to true to avoid throwing an error if the reorder_policy does not exist. A notice is issued instead.

This function returns void.