检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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.
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.
Precautions The user must have the DROP permission in order to delete a resource pool.
RESTRICT: Refuses to delete the trigger if any objects depend on it. This is the default. Examples Delete the trigger insert_trigger: 1 DROP TRIGGER insert_trigger ON test_trigger_src_tbl; Links CREATE TRIGGER, ALTER TRIGGER Parent Topic: DDL Syntax
If command is set to DELETE, only tuple data that meets the condition (the return value of using_expression is TRUE) can be deleted. The operations that are affected include DELETE and DELETE ... RETURNING.
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: automatically deletes objects that depend on the affected objects. RESTRICT (default): refuses to delete objects with dependent objects.
Precautions Only the table owner and users granted the gs_redaction_policy preset role have the permission to delete data masking policies.
RESTRICT Refuses to delete the text search configuration if any objects depend on it. This is the default.
from view %s. errhint: You need an unconditional ON DELETE DO INSTEAD rule or an INSTEAD OF DELETE trigger. level:ERROR GS_231240003 errmsg:transaction left non-empty SPI stack. errhint: Check for missing \SPI_finish\ calls. level:WARNING GS_231240004 errmsg:subtransaction left non-empty
When the UPDATE operation is performed on a table, GaussDB(DWS) logically marks the data to be updated as delete and inserts new data. For the DELETE and UPDATE operations in a table, the data marked as deleted is called discarded tuples.
"vpc:*:get*", "vpc:*:list*", "vpc:*:create*", "vpc:*:delete*", "evs:*:get*", "evs:*:list*", "evs:*:create*", "evs
The owner can use, delete, and manage all resources in the VPC. If principals have resources in the subnet, the owner cannot delete the shared subnet or the VPC where the shared subnet belongs after the share is stopped.
Solution:contact technical support GAUSS-01636: "Unsupport to Update/Delete replication table without PRIMARY KEY" SQLSTATE: XX000 Description: During DELETE or UPDATE execution, the replication table lacks the primary key.
Solution: Delete the current table, rebuild it using CREATE TABLE, and rebuild its physical file.
Handling Procedure To clear system tables for cluster versions earlier than 8.0, run DELETE FROM and then VACUUM FULL.
Solution: Delete the returning lists. GAUSS-03828: "RETURNING lists are not supported in non-INSTEAD rules" SQLSTATE: 0A000 Description: The returning lists are used in the non-INSTEAD rules. Solution: Delete the returning lists.
RESTRICT: refuses to delete the foreign table if any objects depend on it. This is the default behaviour.
Click Delete in the Operation column of the target DR task. In the dialog box that is displayed, click OK. The DR status will change to Deleting. You can delete a DR task when DR Status is Creation failed, Not started, Startup failed, Stopped, Stop failed, or Abnormal.
Table 1 List of short keys Teradata Short Key GaussDB(DWS) Syntax SEL SELECT INS INSERT UPD UPDATE DEL DELETE CT CREATE TABLE CV CREATE VIEW BT START TRANSACTION ET COMMIT Input - BT BT; -- delete from ${BRTL_DCOR}.BRTL_CS_CUST_CID_UID_REL where DW_Job_Seq = ${v_Group_No