检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
If the UPDATE GLOBAL INDEX clause is not used when you delete, split, merge, clear, or exchange partitions, concurrent DML services may report errors due to invalidated indexes.
05-11 11:21:27.243517+08) CSN 15650 0/243EF758 | 98708 | BEGIN 98708 0/243EFA78 | 98708 | COMMIT 98708 (at 2024-05-11 11:22:21.08472+08) CSN 15651 0/243FFD98 | 98710 | BEGIN 98710 0/244000D0 | 98710 | COMMIT 98710 (at 2024-05-11 11:23:21.085542+08) CSN 15653 --More-- Delete
Operations such as SELECT, UPDATE, INSERT, and DELETE can be performed on XML data. The prerequisite is that you have connected to the database using the connection object conn.
If you want to use EXPLAIN ANALYZE on an INSERT, UPDATE, DELETE, CREATE TABLE AS, or EXECUTE statement without letting the statement affect your data, use this approach: 1 2 3 START TRANSACTION; EXPLAIN ANALYZE ...; ROLLBACK; Syntax Display the execution plan of an SQL statement,
Operations such as SELECT, UPDATE, INSERT, and DELETE can be performed on XML data. The prerequisite is that you have connected to the database using the connection object conn.
Otherwise, the performance of DML operations such as INSERT, UPDATE, and DELETE may be affected.
begin; BEGIN gaussdb=# call proc_sys_ref(null); c1 -------------------- <unnamed portal 1> (1 row) gaussdb=# fetch "<unnamed portal 1>"; ERROR: cursor "<unnamed portal 1>" does not exist gaussdb=# end; ROLLBACK gaussdb=# DROP PROCEDURE proc_sys_ref; DROP PROCEDURE -- 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.
Return type: bigint pg_stat_get_last_data_changed_time(oid) Description: Returns the time when INSERT, UPDATE, DELETE, or EXCHANGE/TRUNCATE/DROP PARTITION was last performed on a table.
Return type: bigint pg_stat_get_last_data_changed_time(oid) Description: Returns the time when INSERT, UPDATE, DELETE, or EXCHANGE/TRUNCATE/DROP PARTITION was last performed on a table.
Only simple DELETE statements are supported. For example: DELETE FROM t1 WHERE c1 = ? and c2 = 10; Columns c1 and c2 are index columns, which can be followed by constants or parameters. Only simple UPDATE statements are supported. For example: UPDATE t1 SET c3 = c3+?
To repair the file, you need to delete the file whose size is 0 and then repair it. You can delete a file only after the file descriptor is automatically closed. You can manually restart the process or perform a primary/standby switchover.
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.
CsnMinLock Used to control the concurrent access and storage of CSN MIN HypoIndexLock Used to create, delete and reset the virtual index by the lightweight lock. XGBoostLibLock Used by DB4AI to call the XGBoost library.
If this parameter is set to delete, dependent objects will be automatically deleted when a DROP CASCADE operation is performed on a function or package.
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.
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.
Description Plan hints are specified in the following format after keywords such as SELECT, INSERT, UPDATE, DELETE, and MERGE: 1 /*+ <plan hint>*/ You can specify multiple hints for a query plan and separate them by spaces.
The multinode hint can be added after the select, insert, update, delete, and merge keywords. gtm_host2 Parameter description: Specifies the host name or IP address of the standby GTM 2 if the standby GTM 2 is deployed. This parameter is visible only to the sysadmin user.
[Rule] Once a distribution key is inserted, it cannot be updated unless you delete the key and insert it again.
