Vertica Analytics Platform Version 10.0.x Documentation
Deletes a load balancing group.
DROP LOAD BALANCE GROUP [ IF EXISTS ] group_name [ CASCADE ]
Specifies not to report an error if the load balance group to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.
The name of the group to drop.
Also drops all load balancing routing rules that target this group. If you do not supply this keyword and one or more routing rules target group_name, this statement fails with an error message.
The following statement demonstrates the error you get if the load balancing group has a dependent routing rule, and the use of the CASCADE keyword:
=> DROP LOAD BALANCE GROUP group_all; NOTICE 4927: The RoutingRule catch_all depends on LoadBalanceGroup group_all ROLLBACK 3128: DROP failed due to dependencies DETAIL: Cannot drop LoadBalanceGroup group_all because other objects depend on it HINT: Use DROP ... CASCADE to drop the dependent objects too => DROP LOAD BALANCE GROUP group_all CASCADE; DROP LOAD BALANCE GROUP
Was this topic helpful?