检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
statement to delete table data. 1 DELETE FROM customer_t1 WHERE id = '1009';
Delete automated snapshots. Delete manual snapshots. If you have created a manual snapshot, you can select Manual Snapshot to delete it. After confirming that the information is correct, enter DELETE or click Auto Enter and click OK to delete the cluster.
GAUSS-00516: "cannot drop the default database" SQLSTATE: 42809 Description: Attempting to delete the default database postgres is an invalid operation. Solution: Do not delete the default database postgres and ensure that the operation is correct.
of a user or role are complex and have many dependencies, an error message is displayed when you delete the user or role, indicating that the user or role has dependencies and cannot be deleted.
GAUSS-02396: "cannot delete from foreign table '%s'" SQLSTATE: 0A000 Description: The DELETE operation cannot be performed for foreign tables. Solution: Do not perform the DELETE operation for foreign tables.
GAUSS-00839: "Node list is empty: one node at least is mandatory" SQLSTATE: 42710 Description: When DELETE NODE LIST is run, the node list to be deleted is empty. Solution: Check and modify this statement. Run DELETE NODE LIST for non-empty node lists.
Examples Delete the myView view: 1 DROP VIEW myView; Delete the customer_details_view_v2 view: 1 DROP VIEW public.customer_details_view_v2; Helpful Links ALTER VIEW, CREATE VIEW Parent Topic: DDL Syntax
Delete Click Delete in the plan overview area to delete the current plan. Click OK. Parent Topic: GaussDB(DWS) Resource Load Management
If one of your CNs is abnormal, you can only delete this abnormal CN. If two or more CNs are abnormal, you can delete CNs only after the CNs are recovered from faults. Adding CNs Log in to the DWS console.
Execute DROP...CASCADE only when necessary because this operation will delete the text search configuration that uses this dictionary.
This variable is NULL for DELETE operations. OLD Old tuple for UPDATE/DELETE operations. This variable is NULL for INSERT operations.
If the file is an HDFS table file, delete the HDFS table from the database. If the file is manually created and is not used, delete the file and then delete the tablespace. GAUSS-04612: "Failed to remove external directory '%s'."
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: Deletes objects (such as columns, functions, and operators) that depend on the type. RESTRICT: Refuses to delete the type if any objects depend on it.
SQLSTATE: 42501 Description: Common users are not allowed to delete resource pool objects. Solution: Only system users can delete resource pools. Common users do not have the permission to delete resource pools.
An existing table having a trigger CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: Deletes objects that depend on the trigger. RESTRICT: Refuses to delete the trigger if any objects depend on it.
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: automatically deletes all objects that are contained in the schema to be deleted. RESTRICT: refuses to delete the schema that contains any objects.
Pay-per-Use Resources If you no longer use a GaussDB(DWS) cluster that is in pay-per-use mode, delete it and its resources to stop the billing. You can log in to the DWS console and go to the Clusters page to delete a cluster.
Deleting Resources After performing the steps in "Getting Started," if you do not need to use the sample data, clusters, ECSs, or VPCs, delete the resources so that your service quotas will not be wasted or occupied. Delete a GaussDB(DWS) cluster.
Delete 15 ALTER TABLEPartitioned tableexchange with unloggTable Do not exchange partitioned tables with unlogged tables. Keywords Table 2 Keywords Change Type No.
RESTRICT: Refuses to delete the text search configuration if any objects depend on it. This is the default. This is the default.
