检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
RESTRICT: Refuses to delete the text search configuration if any objects depend on it. This is the default. This is the default.
Delete 15 ALTER TABLEPartitioned tableexchange with unloggTable Do not exchange partitioned tables with unlogged tables. Keywords Table 2 Keywords Change Type No.
If an object whose name is truncated mistakenly cannot be deleted, delete the object using the name before the truncation, or manually delete it from the corresponding system catalog on each node. Database names must comply with the naming convention of SQL identifiers.
RESTRICT: refuses to delete the foreign table if any objects depend on it. This is the default behaviour.
GAUSS-01392: "DELETE trigger's WHEN condition cannot reference NEW values" SQLSTATE: 42P17 Description: New values are quoted in the WHEN clause for DELETE triggers. Solution: Do not quote new values in the WHEN clause for DELETE triggers.
Use either of the following two methods to recreate an index: Run the DROP INDEX statement to delete the index and run the CREATE INDEX statement to create an index. Delete an index. DROP INDEX areaS_idx; DROP INDEX Create an index.
an unconditional ON INSERT DO INSTEAD rule with a RETURNING clause. level:ERROR GS_221100017 errmsg:cannot perform UPDATE RETURNING on relation %s. errhint: You need an unconditional ON UPDATE DO INSTEAD rule with a RETURNING clause. level:ERROR GS_221100018 errmsg:cannot perform DELETE
Use either of the following two methods to recreate an index: Run the DROP INDEX statement to delete the index and run the CREATE INDEX statement to create an index. Delete an index. DROP INDEX areaS_idx; DROP INDEX Create an index.
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 -- Delete all employees in a department from the EMP table. If the department has no employees, delete the department from the DEPT table.
Delete the index before the import.
Delete Locate a query filter and click Delete in the Operation column to delete the filter. Click OK. Parent Topic: GaussDB(DWS) Resource Load Management
To delete the manual snapshots, log in to the GaussDB(DWS) management console and go to the Clusters page.
Handling Procedure When creating a GDS foreign table, delete the specified distribution information, that is, delete the specified DISTRIBUTE BY ROUNDROBIN in the statement. Parent topic: Data Import and Export
GAUSS-00289: "RETURNING cannot contain references to other relations" SQLSTATE: 0A000 Description: The incorrect RETURNING clause in the INSERT/UPDATE/DELETE syntax references another relational table. Solution: Delete the reference on the relational table.
Solution: Delete the abnormal CN, and then delete other CNs. Parent topic: GAUSS-52000 -- GAUSS-52999
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: automatically deletes objects (such as views) that depend on the table to be deleted.
GLOBAL_WORKLOAD_SQL_COUNT GLOBAL_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in all workload Cgroups in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
GS_WORKLOAD_SQL_COUNT GS_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in workload Cgroups on the current node, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: automatically deletes all objects that depend on the index to be deleted. RESTRICT (default): refuses to delete the index if any objects depend on it.
