检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
can periodically execute specific tasks. dbe_sql Advanced function package dbe_sql, which is used to execute dynamic SQL statements and construct query and other commands during application running. dbe_file Advanced function package dbe_file, which is used to read, copy, write, delete
If you select Delete the uploaded file upon an import success, the file you uploaded will be automatically deleted from the OBS bucket after being imported to the destination database. From an OBS bucket In the upper left corner, click Create Task.
Example 1: Delete all elements and spaces of the collection type from the variable of the nest-table collection type. gaussdb=# declare gaussdb-# type nest is table of int; gaussdb-# a nest := nest(1,2,3,4,5); gaussdb-# begin gaussdb$# raise info '%', a; gaussdb$#
Risks and impacts of improper settings: Change the parameter value after fully understanding the parameter meaning and verifying it through testing. enable_save_datachanged_timestamp Parameter description: Specifies whether to record the time when INSERT, UPDATE, DELETE, or EXCHANGE
Syntax Change a type. 1 ALTER TYPE name action [, ... ]; The clauses corresponding to action are as follows: Add a new attribute to a composite type. 1 ADD ATTRIBUTE attribute_name data_type [ COLLATE collation ] [ CASCADE | RESTRICT ] Delete an attribute from a composite type.
INTO V_EMPNO, V_SAL; EXIT WHEN C%NOTFOUND; IF V_SAL<=3000 THEN UPDATE hr.staffs_t1 SET salary =salary + 500 WHERE staff_id = V_EMPNO; END IF; END LOOP; CLOSE C; END; / gaussdb=# CALL cursor_proc2(); cursor_proc2 -------------- (1 row) -- Delete
V_SAL; EXIT WHEN C%NOTFOUND; IF V_SAL<=3000 THEN UPDATE hr.staffs_t1 SET salary =salary + 500 WHERE staff_id = V_EMPNO; END IF; END LOOP; CLOSE C; END; / CREATE PROCEDURE gaussdb=# CALL cursor_proc2(); cursor_proc2 -------------- (1 row) -- Delete
V_SAL; EXIT WHEN C%NOTFOUND; IF V_SAL<=3000 THEN UPDATE hr.staffs_t1 SET salary =salary + 500 WHERE staff_id = V_EMPNO; END IF; END LOOP; CLOSE C; END; / CREATE PROCEDURE gaussdb=# CALL cursor_proc2(); cursor_proc2 -------------- (1 row) -- Delete
gaussdb=# INSERT INTO char_type_t2 VALUES ('too long'::varchar(5)); -- Query data. gaussdb=# SELECT ct_col1, char_length(ct_col1) FROM char_type_t2; ct_col1 | char_length ---------+------------- ok | 2 good | 4 too l | 5 (3 rows) -- Delete
A role with the CREATEROLE permission can also modify and delete other roles. The default value is NOCREATEROLE.
A role with the CREATEROLE permission can also modify and delete other roles. The default value is NOCREATEROLE.
In the centralized deployment scenario where the standby node is readable, you must specify the primary node to run the SQL PATCH command to create, modify, or delete functions and the standby node to report errors.
If a function is defined as IMMUTABLE or SHIPPABLE, avoid INSERT, UPDATE, DELETE, MERGE, and DDL operations in the function because the CN needs to determine the execution node for these operations. Otherwise, an error may occur.
V_EMPNO, V_SAL; EXIT WHEN C%NOTFOUND; IF V_SAL<=3000 THEN UPDATE hr.staffs_t1 SET salary =salary + 500 WHERE staff_id = V_EMPNO; END IF; END LOOP; CLOSE C; END; / CREATE PROCEDURE CALL cursor_proc2(); cursor_proc2 -------------- (1 row) -- Delete
Any DELETE on the same row will also acquire the FOR UPDATE lock mode, as will UPDATE that modifies values on the primary key column.
A positive value indicates that the deletion information of temporary files whose size is larger than the specified value of log_temp_files is recorded. 0 indicates that the delete information of all temporary files is recorded. –1 indicates that the delete information of any temporary
Distribution Real-time percentage of DELETE statements Distributed: all CNs + all DNs Centralized: all DNs % N/A Component 60s rds090_gaussdbv5_statement SQL Statements Real-time number of unique SQL statements Distributed: all CNs Centralized: primary DNs Count N/A Component 1 hour
ledgernsp | usertable | b3a9ed0755131181 | 328b48c4370faed930937869783c23e0 | update ledgernsp. usertable set name = 'bob2' where id = 2; 2 | testdb | omm | 2021-04-14 07:01:29.896148+08 | 16393 | ledgernsp | usertable | 0ae4b4e4ed2fcab5 | aa8f0a236357cac4e5bc1648a739f2ef | delete
ledgernsp | usertable | b3a9ed0755131181 | 328b48c4370faed930937869783c23e0 | update ledgernsp. usertable set name = 'bob2' where id = 2; 2 | testdb | omm | 2021-04-14 07:01:29.896148+08 | 16393 | ledgernsp | usertable | 0ae4b4e4ed2fcab5 | aa8f0a236357cac4e5bc1648a739f2ef | delete
Delete: The index deletion process is added to the UB-tree. The main procedure of index deletion is similar to that of index insertion. That is, obtain the transaction information, fill in the xmax column, and update active_tuple_count on pages.
