检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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
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$#
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
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
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.
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
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
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
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.
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.
A role with the CREATEROLE permission can also modify and delete other roles. The default value is NOCREATEROLE.
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.
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
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
'Beijing','China'); -- Query the table data distributed on the dn_6007_6008_6009 node. gaussdb=# EXECUTE DIRECT ON(dn_6007_6008_6009) 'SELECT * FROM tbl_range'; id | name | province | country -----+--------+----------+--------- 300 | Jordan | Beijing | China (1 row) -- Delete
num2; END; / -- Create an operator class and associate it with the preceding function. gaussdb=# CREATE OPERATOR CLASS oc1 DEFAULT FOR TYPE _int4 USING btree AS FUNCTION 1 func_add_sql (integer, integer); -- Drop the operator. gaussdb=# DROP OPERATOR CLASS oc1 USING btree; -- Delete
=# CREATE SECURITY LABEL sec_label2 'L3:G1-G5'; -- View the security labels created in the system. gaussdb=# SELECT * FROM gs_security_label; label_name | label_content ------------+--------------- sec_label | L1:G4 sec_label1 | L1:G2,G4 sec_label2 | L3:G1-G5 (3 rows) -- Delete
