STV_Rename_Index
Renames a spatial index. If the index format is out of date, you cannot rename the index.
A spatial index is created from an input polygon set, which can be the result of a query. Spatial indexes are created in a global name space. Vertica uses a distributed plan whenever the input table or projection is segmented across nodes of the cluster.
The OVER() clause must be empty.
Behavior Type
Syntax
STV_Rename_Index( USING PARAMETERS source = 'old_index_name', dest = 'new_index_name', overwrite = [ 'true' | 'false' ] ) OVER ()
Arguments
source = 'old_index_name' |
Current name of the spatial index, type VARCHAR. |
dest = 'new_index_name' |
New name of the spatial index, type VARCHAR. |
overwrite = [ 'true' | 'false' ] |
(Optional) BOOLEAN value that specifies whether to overwrite the index, if an index exists. This parameter cannot be NULL. Default: False |
Privileges
Any user with access to the STV_*_Index functions can describe, rename, or drop indexes created by any other user.
Limitations
- Index names cannot exceed 110 characters.
- The backslash or tab characters are not allowed in index names.
Example
The following example shows how to use STV_Rename_Index.
Rename an index:
=> SELECT STV_Rename_Index ( USING PARAMETERS source = 'my_polygons', dest = 'US_states', overwrite = 'false' ) OVER (); rename_index --------------- Index renamed (1 Row)