remove_continuous_aggregate_policy()

Since 1.7.0 Remove all refresh policies from a .

remove_continuous_aggregate_policy(
    continuous_aggregate REGCLASS,
    if_exists BOOL = NULL
) RETURNS VOID

To view the existing policies, see the policies informational view.

Samples

Remove all refresh policies from the cpu_view :

SELECT remove_continuous_aggregate_policy('cpu_view');

The syntax is:

SELECT remove_continuous_aggregate_policy(
    continuous_aggregate = '<view_name>',
    if_exists = true | false
);

Name	Type	Default	Required	Description
`continuous_aggregate`	`REGCLASS`	-	✔	Name of the the policies should be removed from
`if_exists` (formerly `if_not_exists`)	`BOOL`	false	-	When true, prints a warning instead of erroring if the policy doesn’t exist. Renamed in 2.8.

This function returns void.