检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
This API can be called only when the initial user is used and application is gs_rewind. gs_standby_incremental_filemap_execute is used to obtain file information stored in a specified temporary filemap file and delete the specified filemap file for data transmission during incremental
In most cases, you can quickly add or delete table columns, or change the default values of columns. An added column must meet the following requirements. Otherwise, the entire table is updated, leading to additional overheads and affecting online services.
Table 2 Description of permissions Parameter Parameters r SELECT (read) w UPDATE (write) a INSERT (insert) d DELETE D TRUNCATE x REFERENCES t TRIGGER X EXECUTE U USAGE C CREATE c CONNECT T TEMPORARY A ALTER P DROP m COMMENT i INDEX v VACUUM * Authorization options for preceding permissions
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.
Unit: none Value range: origin: The system copies operations such as insert, delete, and update from the current session. replica: The system copies operations such as insert, delete, and update from other places to the current session. local: The system detects the role that has
Users do not need to expand or release storage space, but only need to assign values or delete members.
ON EXAMPLE1 FOR EACH ROW EXECUTE PROCEDURE FUNCTION_TRI_EXAMPLE2(); DELETE FROM EXAMPLE1; DROP TRIGGER TRIGGER_EXAMPLE ON EXAMPLE1; DROP FUNCTION FUNCTION_TRI_EXAMPLE2; DROP TABLE EXAMPLE1; Example 10: Stored procedures that contain IMMUTABLE or SHIPPABLE cannot call COMMIT, ROLLBACK
that the delete information of any temporary files is not recorded.
recorded. –1 indicates that the delete information of any temporary files is not recorded.
inParamWithEmptyElement(conn); // Delete the test object.
inParamWithEmptyElement(conn); // Delete the test object.
\parallel on DELETE FROM range_sales WHERE channel_id = 'T'; ALTER TABLE range_sales ADD PARTITION time_2012 VALUES LESS THAN ('2013-01-01'); \parallel off DQL/DML-DDL Concurrency on the Same Partition GaussDB does not support DQL/DML-DDL concurrency on the same partition.
Drop a backup table. 1 gaussdb=# DROP TABLE customer_t2 CASCADE; If the table to be deleted is dependent on other tables, you need to delete the corresponding tables first. Parent topic: Managing Tables
This API can be called only when the initial user is used and application is gs_rewind. gs_standby_incremental_filemap_execute is used to obtain file information stored in a specified temporary filemap file and delete the specified filemap file for data transmission during incremental
REPLACE PACKAGE BODY pkg_test AS PROCEDURE proc_ist_tbl_test(v_uid in varchar, v_area_id varchar, v_level int) AS BEGIN INSERT INTO tbl_test VALUES (v_uid, v_area_id, v_level); END; PROCEDURE proc_del_tbl_test(v_uid in varchar) AS BEGIN DELETE
Table 2 Description of permissions Parameter Description r SELECT (read) w UPDATE (write) a INSERT (insert) d DELETE D TRUNCATE x REFERENCES t TRIGGER X EXECUTE U USAGE C CREATE c CONNECT T TEMPORARY A ALTER P DROP m COMMENT i INDEX v VACUUM * Authorization options for preceding permissions
Table 2 Description of permissions Parameter Description r SELECT (read) w UPDATE (write) a INSERT (insert) d DELETE D TRUNCATE x REFERENCES t TRIGGER X EXECUTE U USAGE C CREATE c CONNECT T TEMPORARY A ALTER P DROP m COMMENT i INDEX v VACUUM * Authorization options for preceding permissions
Table 2 Description of permissions Parameter Description r SELECT (read) w UPDATE (write) a INSERT (insert) d DELETE D TRUNCATE x REFERENCES t TRIGGER X EXECUTE U USAGE C CREATE c CONNECT T TEMPORARY A ALTER P DROP m COMMENT i INDEX v VACUUM * Authorization options for preceding permissions
In most cases, you can quickly add or delete table columns, or change the default values of columns. An added column must meet the following requirements. Otherwise, the entire table is updated, leading to additional overheads and affecting online services.
In most cases, you can quickly add or delete table columns, or change the default values of columns. An added column must meet the following requirements. Otherwise, the entire table is updated, leading to additional overheads and affecting online services.
