检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Table 1 WORKLOAD_SQL_COUNT columns Name Type Description workload name Workload name. select_count bigint Number of SELECT statements. update_count bigint Number of UPDATE statements. insert_count bigint Number of INSERT statements. delete_count bigint Number of DELETE statements.
If a temporary table is used, delete the temporary table before you return the connection to the connection pool. If you do not do so, the connection in the connection pool will be stateful, which affects subsequent operations on the connection pool.
Its value is NULL. privilege character varying(40) Permissions on an object, including USAGE, UPDATE, DELETE, INSERT, CONNECT, SELECT, and EXECUTE. grantable character varying(3) Specifies whether the grant contains the GRANT option.
Examples 1 2 3 4 -- Delete a CEK. gaussdb=# DROP COLUMN ENCRYPTION KEY ImgCEK CASCADE; ERROR: cannot drop column setting: imgcek cascadely because encrypted column depend on it. HINT: we have to drop encrypted column: name, ... before drop column setting: imgcek cascadely.
RESTRICT: refuses to delete the function if any objects depend on it. This is the default action. Examples For details, see Examples. Helpful Links ALTER FUNCTION and CREATE FUNCTION Parent topic: SQL Syntax
hidden attribute, which must be specified) rulename name Rule name ev_class oid Name of the table that uses the rule ev_attr smallint Column to which this rule applies (always 0 to indicate the entire table) ev_type "char" Event type for the rule. 1: SELECT 2: UPDATE 3: INSERT 4: DELETE
hidden attribute, which must be specified) rulename name Rule name ev_class oid Name of the table that uses the rule ev_attr smallint Column to which this rule applies (always 0 to indicate the entire table) ev_type "char" Event type for the rule. 1: SELECT 2: UPDATE 3: INSERT 4: DELETE
Examples 1 2 3 4 -- Delete a CEK object. gaussdb=# DROP COLUMN ENCRYPTION KEY ImgCEK CASCADE; ERROR: cannot drop column setting: imgcek cascadely because encrypted column depend on it.
RESTRICT: refuses to delete the objects if other objects depend on them. This is the default action. Helpful Links REASSIGN OWNED , DROP ROLE Parent topic: SQL Syntax
Its value is NULL. privilege character varying(40) Permissions on an object, including USAGE, UPDATE, DELETE, INSERT, CONNECT, SELECT, and EXECUTE. grantable character varying(3) Specifies whether the grant contains the GRANT option.
the table. ora_1=# DROP TABLE t1; DROP TABLE -- Switch to the testdb database. ora_1=# \c testdb -- Delete the ORA-compatible database. gaussdb=# DROP DATABASE ora_1; DROP DATABASE Parent topic: Type Conversion
-- Delete the tb_for_masking table. gaussdb=# DROP TABLE tb_for_masking; -- Delete the dev_mask and bob_mask users. gaussdb=# DROP USER dev_mask, bob_mask; Helpful Links ALTER MASKING POLICY and DROP MASKING POLICY Parent topic: C
the table. ora_1=# DROP TABLE t1; DROP TABLE -- Switch to the testdb database. ora_1=# \c testdb -- Delete the ORA-compatible database. gaussdb=# DROP DATABASE ora_1; DROP DATABASE Parent topic: Type Conversion
(The PURGE parameter is added to delete the table data from the recycle bin.) gaussdb=# DROP TABLE tbl_test1 PURGE; Parent topic: T
the table. ora_1=# DROP TABLE t1; DROP TABLE -- Switch to the testdb database. ora_1=# \c testdb -- Delete the ORA-compatible database. openGauss=# DROP DATABASE ora_1; DROP DATABASE Parent topic: Type Conversion
the table. ora_1=# DROP TABLE t1; DROP TABLE -- Switch to the testdb database. ora_1=# \c testdb -- Delete the ORA-compatible database. openGauss=# DROP DATABASE ora_1; DROP DATABASE Parent topic: Type Conversion
the policy. gaussdb=# DROP ROW LEVEL SECURITY POLICY all_data_new_rls ON all_data; -- Delete users alice and bob. gaussdb=# DROP ROLE alice, bob; -- Delete the all_data table. gaussdb=# DROP TABLE all_data; Helpful Links CREATE ROW LEVEL SECURITY POLICY and DROP ROW LEVEL SECURITY
If there are residual files of soft links for the tablespace in the data directory, delete the residual files, and then perform O&M operations. CREATE TABLESPACE cannot be used for two-phase transactions. If it fails on some nodes, the execution cannot be rolled back.
In this way, when the DELTAMERGE operation is concurrently performed with the UPDATE or DELETE operation, one operation can be performed only after the previous one is complete.
If there are residual files of soft links for the tablespace in the data directory, delete the residual files, and then perform O&M operations. CREATE TABLESPACE cannot be used for two-phase transactions. If it fails on some nodes, the execution cannot be rolled back.
