CANCEL_REFRESH
Cancels refresh-related internal operations initiated by START_REFRESH and REFRESH.
Syntax
CANCEL_REFRESH()
Privileges
None
Notes
- Refresh tasks run in a background thread in an internal session, so you cannot use INTERRUPT_STATEMENT to cancel those statements. Instead, use CANCEL_REFRESH to cancel statements that are run by refresh-related internal sessions.
- Run CANCEL_REFRESH() on the same node on which START_REFRESH() was initiated.
- CANCEL_REFRESH() cancels the refresh operation running on a node, waits for the cancelation to complete, and returns SUCCESS.
- Only one set of refresh operations runs on a node at any time.
Example
Cancel a refresh operation executing in the background.
=> SELECT START_REFRESH(); START_REFRESH ---------------------------------------- Starting refresh background process. (1 row)
=> SELECT CANCEL_REFRESH(); CANCEL_REFRESH ---------------------------------------- Stopping background refresh process. (1 row)