检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Not all coordinators can query, modify, and delete tasks created on other CNs. You can create, update, and delete tasks only using the procedures provided by the dbe_task package.
the tpcds.customer_address_p1 table. gaussdb=# DROP TABLE tpcds.customer_address_p1; -- Delete the tpcds.customer_address table. gaussdb=# DROP TABLE tpcds.customer_address; -- Delete a schema. gaussdb=# DROP SCHEMA tpcds CASCADE; Example 2 -- Create tb_a and tb_b. gaussdb=# CREATE
A positive value indicates that the deletion information of temporary files whose size is larger than the specified value of log_temp_files is recorded. 0 indicates that the delete information of all temporary files is recorded. –1 indicates that the delete information of any temporary
Not all coordinators can query, modify, and delete tasks created on other CNs. You can create, update, and delete tasks only using the procedures provided by the DBE_TASK package.
After decoding is complete, set testMode to TEST_MODE_DROP_SLOT to delete the current replication slot.
After decoding is complete, set testMode to TEST_MODE_DROP_SLOT to delete the current replication slot.
Not all coordinators can query, modify, and delete tasks created on other CNs. You can create, update, and delete tasks only using the procedures provided by the DBE_TASK package.
- 3 DELETE Supported. - 4 MERGE Supported. - 5 LOCK TABLE Supported. - 6 INSERT ALL Supported, with differences. Oracle Database does not support alias setting for the tables of into_clause, but GaussDB supports.
ALTER EXTENSION name SET SCHEMA new_schema; Add or delete member objects of the extension.
can periodically execute specific tasks. dbe_sql Advanced function package dbe_sql, which is used to execute dynamic SQL statements and construct query and other commands during application running. dbe_file Advanced function package dbe_file, which is used to read, copy, write, delete
can periodically execute specific tasks. dbe_sql Advanced function package dbe_sql, which is used to execute dynamic SQL statements and construct query and other commands during application running. dbe_file Advanced function package dbe_file, which is used to read, copy, write, delete
Audit of INSERT, UPDATE, and DELETE operations on a specific table Parameter: audit_dml_state Its default value is 0, which indicates that the audit of DML operations (except SELECT) on a specific table is disabled.
Use RELEASE SAVEPOINT to delete a savepoint but keep the effects of the commands executed after the savepoint was established. Savepoints can only be established when inside a transaction block. Multiple savepoints can be defined in a transaction.
Therefore, when the DELETE statements are reversely parsed during distribution key update, multiple partitions are not involved. Data consistency is ensured by the condition tableoid.
Failure to do so may lead to deleting permissions not intended to delete, or not deleting any permissions at all. Examples See Examples in section "GRANT." Helpful Links GRANT Parent topic: SQL Syntax
Failure to do so may lead to deleting permissions not intended to delete, or not deleting any permissions at all. Examples See Examples in "GRANT." Helpful Links GRANT Parent topic: SQL Syntax
Audit of INSERT, UPDATE, and DELETE operations on a specific table Parameter: audit_dml_state Its default value is 0, which indicates that the audit of DML operations (except SELECT) on a specific table is disabled.
Audit of INSERT, UPDATE, and DELETE operations on a specific table Parameter: audit_dml_state Its default value is 0, which indicates that the audit of DML operations (except SELECT) on a specific table is disabled.
double_to_timestamp(double precision) RETURNS TIMESTAMP WITH TIME ZONE AS $$ SELECT to_timestamp($1); $$ LANGUAGE SQL STRICT; -- Create a type conversion. gaussdb=# CREATE CAST(double precision AS timestamp with time zone) WITH FUNCTION double_to_timestamp(double precision) AS IMPLICIT; -- Delete
The initial user is not allowed to create, modify, or delete database links. If the upgrade is not committed, the database link cannot be created.
