检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
If you fail to delete an object by specifying its name after truncation, specify its original name to delete it, or manually delete it from the system catalogs on each node.
If you fail to delete an object by specifying its name after truncation, specify its original name to delete it, or manually delete it from the system catalogs on each node.
RESTRICT: refuses to delete the schema if the schema contains objects. This is the default action. Schemas beginning with pg_temp or pg_toast_temp are for internal use. Do not delete them. Otherwise, unexpected consequences may be incurred.
RESTRICT: refuses to delete the schema if the schema contains objects. This is the default action. Schemas beginning with pg_temp or pg_toast_temp are for internal use. Do not delete them. Otherwise, unexpected consequences may be incurred.
RESTRICT: refuses to delete the schema if the schema contains objects. This is the default action. Schemas beginning with pg_temp or pg_toast_temp are for internal use. Do not delete them. Otherwise, unexpected consequences may be incurred.
the audit policy adt2. gaussdb=# DROP AUDIT POLICY adt2; -- Delete the tb_for_audit table. gaussdb=# DROP TABLE tb_for_audit; -- Delete the dev_audit user. gaussdb=# DROP USER dev_audit; Create an audit policy to audit only the SELECT, INSERT, and DELETE operations performed on
Values are INSERT, UPDATE, DELETE, and TRUNCATE. Multiple events can be specified using OR.
statements (unit: μs) max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs) min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs) avg_delete_elapse bigint Average response time of DELETE statements (unit: μs) Parent topic: Workload
statements (unit: μs) max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs) min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs) avg_delete_elapse bigint Average response time of DELETE statements (unit: μs) Parent topic: Workload
This command can only delete the metadata of key objects recorded in the system catalog of the database, but cannot delete the key entities managed by the client key tool or online key service.
RESTRICT: refuses to delete the server if any objects depend on it. This is the default action.
RESTRICT Refuses to delete the sequence if any objects depend on it. This is the default action.
The system administrator has the permission to delete the specified table by default.
RESTRICT Refuses to delete the sequence if any objects depend on it. This is the default action.
When separation of duties is disabled, a system administrator has the permission to delete the specified table by default.
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
EXEC SQL INSERT INTO foo VALUES (5, 'abc'); Delete a row. EXEC SQL DELETE FROM foo WHERE a = 5; Update table data. EXEC SQL UPDATE foo SET b = 'gdp' WHERE a = 7; Query data in a single row.
EXEC SQL INSERT INTO foo VALUES (5, 'abc'); Delete a row. EXEC SQL DELETE FROM foo WHERE a = 5; Update table data. EXEC SQL UPDATE foo SET b = 'gdp' WHERE a = 7; Query data in a single row.
If an LSN-based logical replication slot remains on the current CN and a CSN-based logical replication slot with the same name remains on other nodes, connecting to a CN to delete a replication slot will delete only the local LSN-based logical replication slot.