检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
When executing DELETED, if ROWNUM with some value (integer) is used, system will DELETE records using the operator near ROWNUM accordingly. 1 2 delete from test1 where c1='abc' and rownum = 1; Output 1 delete from test1 where (xc_node_id,ctid) in (select xc_node_id, ctid from test1
statements. max_delete_elapse Bigint Maximum response time of DELETE statements. min_delete_elapse Bigint Minimum response time of DELETE statements. avg_delete_elapse Bigint Average response time of DELETE statements.
Handling Procedure If t2 does not need to be retained, you can delete the sequence using DROP CASCADE. If you want to retain table t2 and the sequence, you can delete it using the method shown in the following figure. Parent topic: Database Use
statement to delete table data. 1 DELETE FROM customer_t1 WHERE id = '1009';
You can also add, modify, and delete redaction columns. The following table lists the related SQL statements.
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.
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.
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.
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
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.
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.
Delete Click Delete in the plan overview area to delete the current plan. Click OK. Parent Topic: GaussDB(DWS) Resource Load Management
Execute DROP...CASCADE only when necessary because this operation will delete the text search configuration that uses this dictionary.
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 GaussDB(DWS) console.
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'."
This variable is NULL for DELETE operations. OLD Old tuple for UPDATE/DELETE operations. This variable is NULL for INSERT operations.
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.
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.
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.