检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
the reason and reason_t1 tables. gaussdb=# DROP TABLE tpcds.reason; gaussdb=# DROP TABLE tpcds.reason_t1; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds CASCADE; Parent topic: SQL Syntax
To delete an existing user, use DROP USER. To change a user account (for example, rename the user or change the password), use ALTER USER.
You can also run gs_clean -C to manually delete data of inactive sessions. Data is automatically inserted into PLAN_TABLE_DATA after EXPLAIN PLAN is executed. Therefore, do not manually insert data into or update data in PLAN_TABLE_DATA.
To delete an existing user, use DROP USER. To change a user account (for example, rename the user or change the password), use ALTER USER.
REFRESH INCREMENTAL MATERIALIZED VIEW [ view_name ]; Delete a materialized view. DROP MATERIALIZED VIEW [ view_name ]; Query a materialized view.
You can also manually run gs_clean -C to delete inactive session data from the table. Data is automatically inserted into PLAN_TABLE_DATA after EXPLAIN PLAN is executed. Therefore, do not manually insert data into or update data in PLAN_TABLE_DATA.
Table 1 WORKLOAD_SQL_COUNT columns Name Type Description workload name Workload name. select_count bigint Number of SELECT statements. update_count bigint Number of UPDATE statements. insert_count bigint Number of INSERT statements. delete_count bigint Number of DELETE statements.
Table 1 WORKLOAD_SQL_COUNT columns Name Type Description workload name Workload name. select_count bigint Number of SELECT statements. update_count bigint Number of UPDATE statements. insert_count bigint Number of INSERT statements. delete_count bigint Number of DELETE statements.
If you delete a parameter that does not exist, an error will be reported. Examples See Examples. Helpful Links ALTER GLOBAL CONFIGURATION Parent topic: D
If you delete a parameter that does not exist, an error will be reported. Helpful Links ALTER GLOBAL CONFIGURATION Parent topic: SQL Syntax
If you delete a parameter that does not exist, an error will be reported. Helpful Links ALTER GLOBAL CONFIGURATION Parent topic: SQL Syntax
UPDATE, DELETE, and INSERT automatically acquire this lock on the target table and add the ACCESS SHARE lock to other referenced tables. Generally, all statements that modify table data acquire the ROW EXCLUSIVE lock for tables.
Figure 5 Modifying a throttling task To delete a throttling task, click Delete in the Operation column of the task.
To delete an existing user, use DROP USER. To change a user account (for example, rename the user or change the password), use ALTER USER.
the tpcds.customer_demographics_t2 table. gaussdb=# DROP TABLE tpcds.customer_demographics_t2; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds; Helpful Links ROLLBACK Parent topic: C
To delete an existing user, use DROP USER. To change a user account (for example, rename the user or change the password), use ALTER USER.
Execute the following SQL statements to grant them these permissions: 1 2 grant insert,select,delete on pgxc_copy_error_log to {user_name}; grant insert,select,delete on gs_copy_summary to {user_name}; Parent topic: Typical Scenarios
System administrators and common users cannot perform DROP, ALTER, DELETE, UPDATE, and INSERT operations, but can perform the SELECT operation.
Execute the following SQL statements to grant them these permissions: 1 2 GRANT INSERT,SELECT,DELETE ON Pgxc_copy_error_log TO {user_name}; GRANT INSERT,SELECT,DELETE ON gs_copy_summary TO {user_name}; Parent topic: Typical Scenarios
data from PLAN_TABLE. gaussdb=# DELETE FROM plan_table WHERE STATEMENT_ID = 'TPCH-Q4'; gaussdb=# DROP TABLE foo1; gaussdb=# DROP TABLE foo2; Parent topic: SQL Syntax
