检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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
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
Solution: Delete the abnormal CN, and then delete other CNs. Parent topic: GAUSS-52000 -- GAUSS-52999
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.
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.
Data migration dataMigrationDeleteCluster Normal Start to delete the data migration instance. Data migration dataMigrationDeleteClusterApplication Normal Start to delete the job task. Data migration dataMigrationDeleteClusterApplicationFailed Warning Failed to delete the job.
Delete Click Delete in the Operation column of a SQL probe. In the displayed dialog box, enter DELETE or click Auto Enter. Click OK. Parent Topic: Viewing GaussDB(DWS) Cluster Monitoring Information on the Monitoring Panel (DMS)
PGXC_WORKLOAD_SQL_COUNT PGXC_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in workload Cgroups on all CNs in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
GAUSS-00678: "permission denied: '%s' is a system catalog" SQLSTATE: 42501 Description: You have no permission to delete this system catalog. Solution: Do not delete system catalogs.
If there are a large number of UPDATE and DELETE operations, select the User tables. If there are a large number of CREATE and DELETE operations, select System catalogs. Click Next: Configure Schedule to configure the schedule and Vacuum type.
