remove_policies()

Remove refresh, compression, or data retention policies from a continuous aggregate

Early access Since 2.10.0

Remove refresh, , and data retention policies from a . The removed and retention policies apply to the , not to the original .

timescaledb_experimental.remove_policies(
     relation REGCLASS,
     if_exists BOOL = false,
     VARIADIC policy_names TEXT[] = NULL
) RETURNS BOOL

To remove all policies on a , see remove_all_policies().

Samples

Given a named example_continuous_aggregate with a refresh policy and a data retention policy, remove both policies.

Throw an error if either policy doesn’t exist. If the has a policy, leave it unchanged:

SELECT timescaledb_experimental.remove_policies(
    'example_continuous_aggregate',
    false,
    'policy_refresh_continuous_aggregate',
    'policy_retention'
);

Arguments

The syntax is:

SELECT timescaledb_experimental.remove_policies(
    relation = '<view_name>',
    if_exists = true | false,
    policy_names = '<policy_name>', ...
);

Name	Type	Default	Required	Description
relation	REGCLASS	-	✔	The to remove policies from
if_exists	BOOL	false	-	When true, prints a warning instead of erroring if the policy doesn’t exist.
policy_names	TEXT	-	-	The policies to remove. You can list multiple policies, separated by a comma. Allowed policy names are policy_refresh_continuous_aggregate, policy_compression, and policy_retention.

Returns

Returns true if successful.