检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 gaussdb=# CREATE TABLE t1_compfoo(a int, b compfoo); gaussdb=# CREATE TABLE t2_compfoo(a int, b compfoo); -- Change the owner of the user-defined type compfoo1 to usr1. gaussdb=# CREATE USER usr1 PASSWORD '********'; 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 Protects GTM information.
FROM XMLTEST; DELETE 2 gaussdb=# INSERT INTO xmltest VALUES (1, '<?
Keywords such as BEGIN, BY, CLOSE, CURSOR, DECLARE, DELETE, EXECUTE, FUNCTION, IF, IMMEDIATE, INSERT, LOOP, MOVE, OF, REF, RELEASE, RETURN, SAVEPOINT, STRICT, TYPE, and UPDATE without double quotation marks cannot be used as variable names.
Tobias | 30 | 2006-11-15 00:00:00 | yq1 | 30 | 2003-05-18 00:00:00 | yq2 | 30 | 2003-05-18 00:00:00 2007-12-10 00:00:00 | yq3 | 30 | 2003-05-18 00:00:00 (13 rows) -- Delete
Keywords such as BEGIN, BY, CLOSE, CURSOR, DECLARE, DELETE, EXECUTE, FUNCTION, IF, IMMEDIATE, INSERT, LOOP, MOVE, OF, REF, RELEASE, RETURN, SAVEPOINT, STRICT, TYPE, and UPDATE without double quotation marks cannot be used as variable names.
The prototype of the PKG_UTIL.UTILITY_FORMAT_CALL_STACK function is as follows: 1 2 PKG_UTIL.UTILITY_FORMAT_CALL_STACK() RETURN TEXT Example: -- Delete a schema. drop schema if exists pkg_var_test cascade; -- Create a schema named pkg_var_test. create schema pkg_var_test; -- Set
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.
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.
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.
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
--------------+----------------------------+----------------- 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
If this parameter is not supported, delete it from the configuration file first before proceeding with the upgrade. Parent topic: Connection and Authentication
\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.
\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.
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.
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.