Deletes a network address from the catalog. A network address is a name for a IP address and port on a node for use in connection load balancing policies.
Syntax
DROP NETWORK ADDRESS [ IF EXISTS ] address‑name [ CASCADE ]
Parameters
|
Specifies not to report an error if the network address to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them. |
address‑name
|
Name of the network address to drop. |
CASCADE
|
Removes the network address from any load balancing groups that target it. If you do not supply this keyword and one or more load balance groups include this address, this statement fails with an error message. |
Privileges
Examples
The following statement demonstrates the error you get if the network address has a dependent load balance group, and the use of the CASCADE keyword:
=> DROP NETWORK ADDRESS node01; NOTICE 4927: The LoadBalanceGroup group_1 depends on NetworkInterface node01 NOTICE 4927: The LoadBalanceGroup group_random depends on NetworkInterface node01 ROLLBACK 3128: DROP failed due to dependencies DETAIL: Cannot drop NetworkInterface node01 because other objects depend on it HINT: Use DROP ... CASCADE to drop the dependent objects too => DROP NETWORK ADDRESS node01 CASCADE; DROP NETWORK ADDRESS
See Also
- ALTER LOAD BALANCE GROUP
- ALTER NETWORK ADDRESS
- ALTER ROUTING RULE
- Connection Load Balancing Policies
- CREATE LOAD BALANCE GROUP
- CREATE NETWORK ADDRESS
- CREATE ROUTING RULE
- DESCRIBE_LOAD_BALANCE_DECISION
- DROP LOAD BALANCE GROUP
- DROP NETWORK ADDRESS
- DROP ROUTING RULE
- LOAD_BALANCE_GROUPS
- NETWORK_ADDRESSES