CLEAR_PROJECTION_REFRESHES

Clears information in system table PROJECTION_REFRESHES of projection refresh history.

System table PROJECTION_REFRESHES records information about refresh operations, successful and unsuccessful. PROJECTION_REFRESHES retains refresh data until one of the following events occurs:

PROJECTION_REFRESHES checks the Boolean column IS_EXECUTING in PROJECTION_REFRESHES to determine whether refresh operations are still running or are complete. The function only removes information for refresh operations that are complete.

Syntax

CLEAR_PROJECTION_REFRESHES()

Privileges

Superuser

Example

=> SELECT CLEAR_PROJECTION_REFRESHES();
 CLEAR_PROJECTION_REFRESHES
----------------------------
 CLEAR
(1 row)

See Also