检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
DELETE: The DELETE process of enhanced TOAST does not depend on the TOAST data index. Instead, data is traversed and deleted based on the linking information between data. UPDATE: The UPDATE process of enhanced TOAST is the same as that of TOAST. Parent topic: Enhanced TOAST
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.
In the view, the RETURNING clause can be added to the INSERT, UPDATE, and DELETE rules to return columns by view. If a rule is triggered by the INSERT RETURNING, UPDATE RETURNING, or DELETE RETURNING command, these clauses are used to calculate the output result.
a resource label. gaussdb=# DROP RESOURCE LABEL func_label, view_label, schema_label, column_label, table_label; -- Delete the func_for_label function. gaussdb=# DROP FUNCTION func_for_label; -- Delete the view_for_label view. gaussdb=# DROP VIEW view_for_label; -- Delete the
In the view, the RETURNING clause can be added to the INSERT, UPDATE, and DELETE rules to return columns by view. If a rule is triggered by the INSERT RETURNING, UPDATE RETURNING, or DELETE RETURNING command, these clauses are used to calculate the output result.
RESTRICT: refuses to delete the materialized view if any objects depend on it. This is the default action.
FOR SHARE/UPDATE is used to lock rows in a transaction, other transactions cannot modify or delete these rows. When FOR SHARE is used to lock a row, the current transaction and other transactions cannot modify or delete the locked row.
RESTRICT: refuses to delete the materialized view if any objects depend on it. This is the default action.
name char(50), address varchar(255)); Concurrent INSERT and DELETE in the Same Table Concurrent INSERT in the Same table Concurrent UPDATE in the Same Table Concurrent Data Import and Queries Parent topic: Managing Concurrent Write Operations
name char(50), address varchar(255)); Concurrent INSERT and DELETE in the Same Table Concurrent INSERT in the Same table Concurrent UPDATE in the Same Table Concurrent Data Import and Queries Parent topic: Managing Concurrent Write Operations
If you do not need the backups anymore, delete them manually. If your instance is frozen, its backups are not billed. Automated backups and their related files are automatically deleted. Parent topic: Backup and Restoration
-- Delete the view resource label view_for_label. gaussdb=# DROP VIEW view_for_label; -- Delete the schema resource label schema_for_label. gaussdb=# DROP SCHEMA schema_for_label; -- Delete the tb_for_label table. gaussdb=# DROP TABLE tb_for_label; Helpful Links ALTER RESOURCE
a masking policy. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of masking policies. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol2, maskpol3; -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL mask_lb1; gaussdb=# DROP RESOURCE LABEL mask_lb2; gaussdb
a masking policy. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of masking policies. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol2, maskpol3; -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL mask_lb1; gaussdb=# DROP RESOURCE LABEL mask_lb2; gaussdb
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 materialized view if any objects depend on it. This is the default action.
RESTRICT: refuses to delete a materialized view if any objects depend on it. This is the default value.
RESTRICT: refuses to delete the materialized view if any objects depend on it. This is the default action.
Value range: an existing database name Examples -- Create a database. gaussdb=# CREATE DATABASE testdb1; -- Delete the database. gaussdb=# DROP DATABASE testdb1; Helpful Links CREATE DATABASE Suggestions DROP DATABASE Do not delete databases during transactions. Parent topic: D
RESTRICT: refuses to delete a materialized view if any objects depend on it. This is the default value.
