DROP LOAD BALANCE GROUP
Deletes a load balancing group.
Syntax
DROP LOAD BALANCE GROUP [ IF EXISTS ] group_name [ CASCADE ]
Parameters
IF EXISTS
|
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. |
group_name |
The name of the group to drop. |
[CASCADE] |
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. |
Privileges
Examples
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
See Also