检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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.
ALGORITHM=INSTANT: Users can add columns instantly and delete columns instantly anywhere in a table, and evaluate row size limits when adding a column. This is not supported by GaussDB(DWS) and is deleted by DSC during the migration.
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 to the TRUNCATE statement for 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.
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 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.
After a GaussDB(DWS) cluster is created, you can change its security group or you can add, delete, or modify rules in its current security group. Change the security group to another one: Log in to the GaussDB(DWS) console.
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 add, delete, or modify rules in its current security group. Modify an existing security group rule: Log in to the GaussDB(DWS) management console. Choose Dedicated Clusters > Clusters in the navigation pane.
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.
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.
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
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
You can also add, modify, and delete redaction columns. The following table lists the related SQL statements.
