检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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.
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.
RESTRICT: refuses to delete the index if any objects depend on it. This is the default action.
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.
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 rule if any objects depend on it. The default value is used.
To delete partial data, use the DELETE operation. If log files occupy too much storage, clear log files to release storage space. If temporary files generated by sorting queries occupy too much storage space, optimize your SQL statements. Parent Topic: Database Storage
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.
resource labels. 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 schema_for_label
ROLES(dev_audit, bob_audit), APP(gsql), IP('10.20.30.40', '127.0.0.0/24'); -- Delete an audit policy. gaussdb=# DROP AUDIT POLICY adt1, adt2, adt3, adt4; -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL adt_lb0; -- Delete the tb_for_audit table. gaussdb=# DROP TABLE tb_for_audit
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.
ROLES(dev_audit, bob_audit), APP(gsql), IP('10.20.30.40', '127.0.0.0/24'); -- Delete the audit policy. gaussdb=# DROP AUDIT POLICY adt1, adt2, adt3, adt4; -- Delete the resource label. gaussdb=# DROP RESOURCE LABEL adt_lb0; -- Delete the tb_for_audit table. gaussdb=# DROP TABLE
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
RESTRICT: refuses to delete the index if any objects depend on it. This is the default action.
When you delete an extension, the components that make up the extension are also deleted. The DROP EXTENSION command can be used only by the owner of the extension.
When you delete an extension, the components that make up the extension are also deleted. The DROP EXTENSION command can be used only by the owner of the extension.
