remove_continuous_aggregate_policy()

Remove the refresh policy from a continuous aggregate.

  2. remove_continuous_aggregate_policy(
  4.     continuous_aggregate REGCLASS,
  6.     if_exists BOOL = NULL
  8. ) RETURNS VOID
note

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

Required arguments

NameTypeDescription
continuous_aggregateREGCLASSName of the continuous aggregate the policy should be removed from

Optional arguments

NameTypeDescription
if_exists (formerly if_not_exists)BOOLWhen true, prints a warning instead of erroring if the policy doesn’t exist. Defaults to false. Renamed in TimescaleDB 2.8.

Sample usage

Remove the refresh policy from the cpu_view continuous aggregate:

  2. SELECT remove_continuous_aggregate_policy('cpu_view');