检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
hr.staffs where staff_id = :1' INTO first_name, salary USING IN staff_id; dbe_output.print_line(first_name || ' ' || salary); END; / CREATE PROCEDURE -- Call the stored procedure. gaussdb=# CALL dynamic_proc(); mike 5800.00 dynamic_proc -------------- (1 row) -- Delete
END; END LOOP; END; $$ LANGUAGE plpgsql; CREATE FUNCTION gaussdb=# SELECT merge_db(1, 'david'); merge_db ---------- (1 row) gaussdb=# SELECT merge_db(1, 'dennis'); merge_db ---------- (1 row) -- Delete FUNCTION and TABLE. gaussdb=# DROP FUNCTION merge_db; DROP FUNCTION
----------+----------------+----------- 1501 | vivitar 35mm | electrncs 1502 | olympus camera | electrncs 1600 | play gym | toys 1601 | lamaze | toys 1666 | harry potter | toys 1700 | wait interface | books (6 rows) -- Delete
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
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
with the wg1 Workload Cgroup under class1. gaussdb=# CREATE RESOURCE POOL pool4 WITH (CONTROL_GROUP="class1:wg1"); -- Create a resource pool, and associate it with the wg2 Workload Cgroup under class1. gaussdb=# CREATE RESOURCE POOL pool5 WITH (CONTROL_GROUP="class1:wg2:3"); -- Delete
hr.staffs where staff_id = :1' INTO first_name, salary USING IN staff_id; dbe_output.print_line(first_name || ' ' || salary); END; / CREATE PROCEDURE -- Call the stored procedure. gaussdb=# CALL dynamic_proc(); mike 5800.00 dynamic_proc -------------- (1 row) -- Delete
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
permission for myschema to the user. 1 2 3 4 gaussdb=# CREATE USER jack IDENTIFIED BY '********'; CREATE ROLE gaussdb=# GRANT USAGE ON schema myschema TO jack; GRANT Revoke the usage permission for myschema from jack. 1 2 gaussdb=# REVOKE USAGE ON schema myschema FROM jack; REVOKE Delete
The DROP INDEX statement cannot be used to delete these indexes. You need to use the DROP INDEX IF EXISTS statement to delete them.
DELETE statements containing subqueries are not supported. MERGE INTO statements containing subqueries in INSERT or UPDATE are not supported. Concurrent UPDATE, DELETE, or MERGE INTO operations with conflicting tuples are not supported.
In addition, you can flexibly create, delete, or change a SQL patch as needed. In actual GaussDB O&M scenarios, unique SQL IDs are used to locate query statements (normal-stmt and prepared-stmt) and hints are used to optimize query performance.
If the row to which the cursor points does not exist, an error is reported (only when UPDATE is used instead of DELETE) in the A-compatible mode, indicating that the specified row does not exist. In other compatibility modes, no error is reported.
If the decoding is interrupted because the user does not exist and the corresponding blacklisted user does not exist at the time when logs are generated, you can set dynamic-resolution to true or delete the username from the blacklist to start decoding and continue to obtain logical
Delete the logs after using them. Do not call the function when debug_print_plan is set to on, preventing the risk of sensitive information disclosure.
----------+----------------+----------- 1501 | vivitar 35mm | electrncs 1502 | olympus camera | electrncs 1600 | play gym | toys 1601 | lamaze | toys 1666 | harry potter | toys 1700 | wait interface | books (6 rows) -- Delete
hr.staffs where staff_id = :1' INTO first_name, salary USING IN staff_id; dbe_output.print_line(first_name || ' ' || salary); END; / CREATE PROCEDURE -- Call the stored procedure. gaussdb=# CALL dynamic_proc(); mike 5800.00 dynamic_proc -------------- (1 row) -- Delete
out var3; dbe_output.print_line('var3: ' || var3); END; / CREATE PROCEDURE -- Call the stored procedure. gaussdb=# CALL dynamic_proc(); mike 5800.00 dynamic_proc -------------- (1 row) gaussdb=# CALL dynamic_proc1(); var3: 4 dynamic_proc1 --------------- (1 row) -- Delete
out var3; dbe_output.print_line('var3: ' || var3); END; / CREATE PROCEDURE -- Call the stored procedure. gaussdb=# CALL dynamic_proc(); mike 5800.00 dynamic_proc -------------- (1 row) gaussdb=# CALL dynamic_proc1(); var3: 4 dynamic_proc1 --------------- (1 row) -- Delete
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.
