检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
The following functions are affected: To delete the base column of a generated column, you need to delete the corresponding generated column first. The SET NULL, SET DEFAULT, and CASCADE keywords cannot be associated with the ON UPDATED and ON DELETE actions.
date_lt_timestamp date_lt_timestamptz date_mi date_mi_interval date_mii date_ne date_ne_timestamp date_ne_timestamptz date_out date_pl_interval date_pli date_recv date_send date_smaller date_sortsupport daterange_canonical daterange_subdiff datetime_pl datetimetz_pl dcbrt decode defined degrees delete
If this parameter is not supported, delete it from the configuration file first before proceeding with the upgrade. Parent topic: Connection and Authentication
--------------+----------------------------+----------------- now | 2023-02-27 11:38:13 | 2023-02-27 11:38:13.032815 | 11:38:13.032815 today | 2023-02-27 00:00:00 | 2023-02-27 00:00:00 | tomorrow | 2023-02-28 00:00:00 | 2023-02-28 00:00:00 | (3 rows) -- Delete
GTM Wait event gtm drop sequence Waits for GTM to delete a sequence. GTM Wait event gtm rename sequence Waits for GTM to rename a sequence. GTM LWLock event GTMHostInfoLock Used to protect GTM information.
CALL proc_raw(); 6 proc_raw ---------- (1 row) -- Delete the stored procedure. DROP PROCEDURE proc_raw; DROP PROCEDURE DECLARE v_raw RAW; v_double BINARY_DOUBLE; v_float FLOAT4; v_numeric NUMERIC; v_nvarchar2 NVARCHAR2; BEGIN -- Perform bitwise AND calculation on RAW values.
GTM Wait event gtm drop sequence Waits for GTM to delete a sequence. GTM Wait event gtm rename sequence Waits for GTM to rename a sequence. GTM LWLock event GTMHostInfoLock Protects GTM information.
The multinode hint can be added after the select, insert, update, delete, and merge keywords. Setting method: This parameter is a USERSET parameter and cannot be set using gs_guc.
date_lt_timestamp date_lt_timestamptz date_mi date_mi_interval date_mii date_ne date_ne_timestamp date_ne_timestamptz date_out date_pl_interval date_pli date_recv date_send date_smaller date_sortsupport daterange_canonical daterange_subdiff datetime_pl datetimetz_pl dcbrt decode defined degrees delete
\nEND ldp_pkg1; \n /"} (1 row) Delete the logical replication slot slot1 and package ldp_pkg1. 1 2 3 4 5 6 7 8 9 gaussdb=# SELECT * FROM pg_drop_replication_slot('slot1'); pg_drop_replication_slot -------------------------- (1 row) gaussdb=# DROP PACKAGE ldp_pkg1; NOTICE: drop
Return type: timestamptz pg_stat_set_last_data_changed_time(oid) Description: Manually changes the time when INSERT, UPDATE, DELETE, or EXCHANGE/TRUNCATE/DROP PARTITION was last performed.
tab_2(col2 char(3)); openGauss=# insert into tab_2 values(' '); openGauss=# insert into tab_1 select col2 from tab_2; openGauss=# select * from tab_1 where col1 is null; col1 ------ (1 row) openGauss=# select * from tab_1 where col1=' '; col1 ------ (0 rows) openGauss=# delete
DATE, employment_ID VARCHAR2(10), SALARY NUMBER(8,2), COMMISSION_PCT NUMBER(2,2), MANAGER_ID NUMBER(6), section_ID NUMBER(4) ) SERVER gsmpp_server OPTIONS (location 'file:///output_data/', format 'csv', delimiter '|', header 'on') WRITE ONLY; 1 2 3 4 5 -- Delete
Delete the table and restore the environment. */ RETURN_IF_NOT_SUCCESS(execute_cmd(sql_drop)); RETURN_IF_NOT_SUCCESS(commit_exec()); end_unit_test(); } In the preceding example, the number column is defined.
date_lt_timestamp date_lt_timestamptz date_mi date_mi_interval date_mii date_ne date_ne_timestamp date_ne_timestamptz date_out date_pl_interval date_pli date_recv date_send date_smaller date_sortsupport daterange_canonical daterange_subdiff datetime_pl datetimetz_pl dcbrt decode defined degrees delete
HypoIndexLock Used to create, delete and reset the virtual index by the lightweight lock. XGBoostLibLock Used by DB4AI to call the XGBoost library. DropArchiveSlotLock Used to protect the concurrent sequence of deleting the archive slot.
\nEND ldp_pkg1; \n /"} (1 row) Delete the logical replication slot slot1 and package ldp_pkg1. 1 2 3 4 5 6 7 8 9 db1=> SELECT * FROM pg_drop_replication_slot('slot1'); pg_drop_replication_slot -------------------------- (1 row) gaussdb=# DROP PACKAGE ldp_pkg1; NOTICE: drop cascades
Delete the table and restore the environment. */ RETURN_IF_NOT_SUCCESS(execute_cmd(sql_drop)); RETURN_IF_NOT_SUCCESS(commit_exec()); end_unit_test(); } In the preceding example, the number column is defined.
The desired access permission is specified by a text string, which must be SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, ALTER, DROP, COMMENT, INDEX or VACUUM.
Return type: record DBE_PERF.get_global_statement_count() Description: Aggregates SELECT, UPDATE, INSERT, DELETE, and response time information (TOTAL, AVG, MIN, and MAX) on each node.
