检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Click Delete in the Operation column of a report to delete the report record and file. Configuring Workload Report Parameters Log in to the GaussDB(DWS) management console.
Solution: Delete the CHECK constraint. GAUSS-01222: "cannot copy to view '%s'" SQLSTATE: 42809 Description: Failed to use COPY to copy data to a view. Solution: Do not use COPY to copy data to a view.
TRUNCATE (Table Deletion) In MySQL, the TABLE keyword can be omitted when the TRUNCATE statement is used to delete table data. GaussDB(DWS) does not support this usage. In addition, DSC will add CONTINUE IDENTITY RESTRICT during TRUNCATE migration.
Deleting a Subscribed Event Function This API is used to delete a subscribed event. Call Method For details, see Calling APIs. URI DELETE /v2/{project_id}/event-subs/{event_sub_id} Table 1 URI parameters Parameter Mandatory Type Description project_id Yes String Project ID.
Deleting an Alarm Subscription Function This API is used to delete a subscribed alarm. Call Method For details, see Calling APIs. URI DELETE /v2/{project_id}/alarm-subs/{alarm_sub_id} Table 1 URI parameters Parameter Mandatory Type Description project_id Yes String Project ID.
After you delete data stored in GaussDB(DWS) data warehouses, dirty data may be generated possibly because the disk space is not released. This results in disk space waste and deteriorates snapshot creation and restoration performance.
DROP (Table Deletion) Both GaussDB(DWS) and MySQL support using the DROP statement to delete tables. However, GaussDB(DWS) does not support the RESTRICT | CASCADE keyword in the DROP statement. DSC will delete the keywords during migration.
SQL Self-Diagnosis Performance problems may occur when you run the INSERT/UPDATE/DELETE/SELECT/MERGE INTO or CREATE TABLE AS statement. The product supports automatic performance diagnosis and saves related diagnosis information to the Real-time Top SQL.
SQL Self-Diagnosis Performance issues may occur when you run the INSERT/UPDATE/DELETE/SELECT/MERGE INTO or CREATE TABLE AS statement. The product supports automatic performance diagnosis and saves related diagnosis information to Real-time Top SQL.
SQL Self-Diagnosis Performance issues may occur when you run the INSERT/UPDATE/DELETE/SELECT/MERGE INTO or CREATE TABLE AS statement. The product supports automatic performance diagnosis and saves related diagnosis information to Real-time Top SQL.
However, you can add, delete, or modify rules of the current security group. To edit the cluster security group: Log in to the GaussDB(DWS) management console. In the navigation pane on the left, click Clusters.
GAUSS-02721 -- GAUSS-02730 GAUSS-02725: "partition %u deleted while still in use" SQLSTATE: XX000 Description: The SQL statement failed to be scheduled. Solution: The partition in use cannot be deleted. Modify the scheduling statement. GAUSS-02726: "partition %u is still open" SQLSTATE
After a GaussDB(DWS) cluster is created, you can modify its security group settings, or you can add, delete, or modify security group rules in the current security group. Change the security group to another one: Log in to the GaussDB(DWS) management console.
A user cannot delete the schema in use. To delete the schema in use, switch to another schema. Example Delete the ds_new schema: DROP SCHEMA ds_new; Links ALTER SCHEMA, CREATE SCHEMA Parent topic: DDL Syntax
A user cannot delete the schema in use. To delete the schema in use, switch to another schema. Example Delete the ds_new schema: DROP SCHEMA ds_new; Links ALTER SCHEMA, CREATE SCHEMA Parent topic: DDL Syntax
Do not delete the schemas with the beginning of pg_temp or pg_toast_temp. They are internal system schemas, and deleting them may cause unexpected errors. A user cannot delete the schema in use. To delete the schema in use, switch to another schema.
max_delete_elapse bigint Maximum response time of DELETE min_delete_elapse bigint Minimum response time of DELETE avg_delete_elapse bigint Average response time of DELETE Parent topic: System Views
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 Parent topic: System Views
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 Parent topic: System Views
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 Parent topic: System Views
