检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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.
The LOAD DATA syntax requires the INSERT and DELETE permissions on tables. If the data written to a table by running LOAD DATA cannot be converted to the data type of the table, the import fails. LOAD DATA applies only to tables but not views.
Character strings stored in user-defined variables in the PREPARE statement support only the SELECT, INSERT, UPDATE, DELETE, and MERGE syntax.
The LOAD DATA syntax requires the INSERT and DELETE permissions on tables. If the data written to a table by running LOAD DATA cannot be converted to the data type of the table, the import fails. LOAD DATA applies only to tables but not views.
If the third digit is 1, a delete operation is recorded. If the second digit is 1, an insert operation is recorded.
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,
display table information. gaussdb=# ANALYZE VERBOSE customer_info; INFO: analyzing "public.customer_info"(cn_5002 pid=53078) INFO: analyzing "public.customer_info" inheritance tree(cn_5002 pid=53078) ANALYZE If any environment-related fault occurs, check the logs of CN. 1 2 3 -- 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.
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. off: The DELTAMERGE operation is concurrently performed with the UPDATE or DELETE operation to the data
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.
Return type: record pgxc_get_sql_count() Description: Provides the counts of the SELECT, UPDATE, INSERT, DELETE, and MERGE INTO statements executed on all the nodes in the entire cluster.
If an existing object references to an object in another schema, you need to manually delete the referenced object first. gs_restore backup/MPPDB_backup.dmp -p 8000 -d testdb -e -c -n PUBLIC Error while PROCESSING TOC: Error from TOC entry 313; 1259 337399 TABLE table1 gaussdba could
ON EXAMPLE1 FOR EACH ROW EXECUTE PROCEDURE FUNCTION_TRI_EXAMPLE2(); CREATE TRIGGER gaussdb=# DELETE FROM EXAMPLE1; ERROR: Can not commit/rollback if it's atomic is true: can not use commit rollback in Complex SQL CONTEXT: PL/pgSQL function function_tri_example2() line 7 at COMMIT
In the centralized deployment scenario where the standby node is readable, you must specify the primary node to call functions to create, modify, or delete SQL patches and the standby node to report errors. There is a delay in synchronizing an SQL patch to the standby node.
t1 "_REMOTE_TABLE_QUERY_" (cost=0.00..0.00 rows=20 width=12) Node/s: All datanodes -> Hash (cost=0.00..0.00 rows=20 width=12) -> Data Node Scan on t "_REMOTE_TABLE_QUERY_" (cost=0.00..0.00 rows=20 width=12) Node/s: All datanodes (7 rows) Delete
DROP: allows users to delete a specified object. has_nodegroup_privilege(nodegroup, privilege) Description: Checks whether a user has the permission to access a cluster node.
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.
Table 5 Description of permissions Parameter Description r SELECT: allows users to read data from specified tables and views. w UPDATE: allows users to update columns for specified tables. a INSERT: allows users to insert data to specified tables. d DELETE: allows users to delete
Table 5 Description of permissions Parameter Description r SELECT: allows users to read data from specified tables and views. w UPDATE: allows users to update columns for specified tables. a INSERT: allows users to insert data to specified tables. d DELETE: allows users to delete
