ENFORCE_OBJECT_STORAGE_POLICY
Applies storage policies of the specified object immediately. By default, the Tuple Mover enforces object storage policies after all pending mergeout operations are complete. Calling this function is equivalent to setting the enforce-storage-move
parameter on related meta-functions. You typically use this function as the last step before dropping a storage location.
Syntax
ENFORCE_OBJECT_STORAGE_POLICY ( 'object‑name' [,'key‑min', 'key‑max'] )
Parameters
object‑name |
Identifies the database object whose storage policies are to be applied, one of the following:
In all cases, database must be the name of the current database. |
key‑min
|
Valid only if object‑name is a table, specifies the range of table partition key values on which to perform the move. |
Privileges
One of the following:
- Superuser
- Object owner and access to its storage location.
Examples
Apply storage policy updates to the test
table:
=> SELECT ENFORCE_OBJECT_STORAGE_POLICY ('test');