检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Values are INSERT, UPDATE, DELETE, and TRUNCATE. Multiple events can be specified using OR.
user bob_audit. gaussdb=# DROP USER bob_audit; Delete the filter criteria from the audit policy. -- Delete the filter criteria in the adt1 audit policy. gaussdb=# ALTER AUDIT POLICY adt1 DROP FILTER; Disable the audit policy. -- Disable the adt1 audit policy. gaussdb=# ALTER AUDIT
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.
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.
This section describes how to use SQL statements to delete tables or table data.
Examples Delete the list of parameters that can be omitted when a function. -- Create a function. gaussdb=# CREATE FUNCTION func_test(varchar) RETURN VARCHAR AS BEGIN RETURN $1||_'test'; END; / -- Delete the function. gaussdb=# DROP FUNCTION func_test; Delete a function with
Examples Delete the list of parameters that can be omitted when a function. -- Create a function. gaussdb=# CREATE FUNCTION func_test(varchar) RETURN VARCHAR AS BEGIN RETURN $1||_'test'; END; / -- Delete the function. gaussdb=# DROP FUNCTION func_test; Delete a function with
Values are INSERT, UPDATE, DELETE, and TRUNCATE. Multiple events can be specified using OR.
plpgsql; -- Create a DELETE trigger. gaussdb=# CREATE TRIGGER delete_trigger BEFORE DELETE ON test_trigger_src_tbl FOR EACH ROW EXECUTE PROCEDURE tri_delete_func(); -- Rename a trigger. gaussdb=# ALTER TRIGGER delete_trigger ON test_trigger_src_tbl RENAME TO delete_trigger_renamed
plpgsql; -- Create a DELETE trigger. gaussdb=# CREATE TRIGGER delete_trigger BEFORE DELETE ON test_trigger_src_tbl FOR EACH ROW EXECUTE PROCEDURE tri_delete_func(); -- Rename a trigger. gaussdb=# ALTER TRIGGER delete_trigger ON test_trigger_src_tbl RENAME TO delete_trigger_renamed
Values are INSERT, UPDATE, DELETE, and TRUNCATE. Multiple events can be specified using OR.
To delete it, switch to another schema first.
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.
There are three scenarios: COORDINATOR: Delete the idle or invalid connections from the current CN to a specified CN. NODE: Delete the idle or invalid connections from the current CN to a specified DN.
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.
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
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
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.
