检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
WHERE id1=OLD.id1; RETURN OLD; END $$ LANGUAGE 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(); -- Execute the DELETE event
WHERE id1=OLD.id1; RETURN OLD; END $$ LANGUAGE 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(); -- Execute the DELETE event
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
PGXC_GET_STAT_ALL_TABLES PGXC_GET_STAT_ALL_TABLES displays information about INSERT, UPDATE, and DELETE operations on tables and the dirty page rate of tables.
DBE_SQL_UTIL.drop_sql_patch drop_sql_patch is a function used to delete SQL patches. It returns whether the execution is successful, as described in Table 1. Only the initial user, sysadmin, opradmin, and monadmin have the permission to call this API.
The differences between TRUNCATE, DELETE, and DROP are as follows: TRUNCATE TABLE deletes content, releases space, but does not delete definitions. DELETE TABLE deletes content, but does not delete definitions nor release space.
The differences between TRUNCATE, DELETE, and DROP are as follows: TRUNCATE TABLE deletes content, releases space, but does not delete definitions. DELETE TABLE deletes content, but does not delete definitions nor release space.
The differences between TRUNCATE, DELETE, and DROP are as follows: TRUNCATE TABLE deletes content, releases space, but does not delete definitions. DELETE TABLE deletes content, but does not delete definitions nor release space.
The differences between TRUNCATE, DELETE, and DROP are as follows: TRUNCATE TABLE deletes content and releases space, but does not delete definitions. DELETE TABLE deletes content, but does not delete definitions nor release space.
Precautions To delete a type conversion, you must have permissions on the source or destination data type. This is the same permission as creating a type conversion.
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). dbid oid ID of the
The differences between TRUNCATE, DELETE, and DROP are as follows: TRUNCATE TABLE deletes content, releases space, but does not delete definitions. DELETE TABLE deletes content, but does not delete definitions nor release space.
For example, delete the partition date_202005 from the level-2 partitioned table range_list_sales by specifying the partition name and update the global index.
For example, delete the partition date_202005 from the level-2 partitioned table range_list_sales by specifying the partition name and update the global index.
RESTRICT: refuses to delete the data source if any objects depend on it. This is the default action. Currently, no objects depend on data sources. Therefore, CASCADE is equivalent to RESTRICT, and they are reserved to ensure backward compatibility.
The differences between TRUNCATE, DELETE, and DROP are as follows: TRUNCATE TABLE deletes content, releases space, but does not delete definitions. DELETE TABLE deletes content, but does not delete definitions nor release space.
RESTRICT: refuses to delete the data source if any objects depend on it. This is the default action. Currently, no objects depend on data sources. Therefore, CASCADE is equivalent to RESTRICT, and they are reserved to ensure backward compatibility.
Creating an Index Online delete_cctmp_table Parameter description: Specifies whether to delete temporary tables generated during Ustore online index creation or rebuilding. This parameter can be set at the PDB level. Parameter type: Boolean.
Precautions Only the table owner or administrators can delete a row-level access control policy from the table.
You can call DBE_PROFILER.PL_CLEAR_PROFILING to delete one piece of data or all data stored in the system catalog after profiling.
