检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
If you fail to delete an object whose name is truncated mistakenly, specify its original name to delete it, or manually delete it from the corresponding system catalog on each node.
users alice and bob. gaussdb=# DROP ROLE alice, bob; -- Delete the policy. gaussdb=# DROP ROW LEVEL SECURITY POLICY all_data_new_rls ON all_data; -- Delete the all_data table. gaussdb=# DROP TABLE all_data; Helpful Links CREATE ROW LEVEL SECURITY POLICY and DROP ROW LEVEL SECURITY
the test_v1 view. gaussdb=# DROP VIEW tcpds.test_v1; DROP VIEW -- Delete the test_tb1 table. gaussdb=# DROP TABLE test_tb1; DROP TABLE -- Delete the user. gaussdb=# DROP ROLE role_test; DROP ROLE -- Delete the schema. gaussdb=# DROP SCHEMA tcpds; DROP SCHEMA Helpful Links CREATE
the encrypted table. gaussdb=# DROP TABLE creditcard_info; DROP TABLE -- Delete the column key. gaussdb=# DROP COLUMN ENCRYPTION KEY cek1; DROP COLUMN ENCRYPTION KEY -- Delete the master key. gaussdb=# DROP CLIENT MASTER KEY cmk1; DROP CLIENT MASTER KEY Parent topic: Setting Encrypted
the encrypted table. gaussdb=# DROP TABLE creditcard_info; DROP TABLE -- Delete the column key. gaussdb=# DROP COLUMN ENCRYPTION KEY cek1; DROP COLUMN ENCRYPTION KEY -- Delete the master key. gaussdb=# DROP CLIENT MASTER KEY cmk1; DROP CLIENT MASTER KEY Parent topic: Setting Encrypted
Delete user jack. 1 2 gaussdb=# DROP USER jack CASCADE; DROP ROLE Delete tables foo and foo2. 1 2 gaussdb=# DROP TABLE foo; gaussdb=# DROP TABLE foo2; If the following information is displayed, the deletion is successful: 1 DROP TABLE Delete tablespace fspace. 1 2 gaussdb=# DROP
Example -- Delete the foreign data wrapper dbi. gaussdb=# DROP FOREIGN DATA WRAPPER dbi; Helpful Links CREATE FOREIGN DATA WRAPPER and ALTER FOREIGN DATA WRAPPER Parent topic: D
D DEALLOCATE DECLARE DELETE DO DROP AGGREGATE DROP AUDIT POLICY DROP CLIENT MASTER KEY DROP COLUMN ENCRYPTION KEY DROP DATABASE DROP DATABASE LINK DROP DIRECTORY DROP EXTENSION DROP FOREIGN DATA WRAPPER DROP FOREIGN TABLE DROP FUNCTION DROP GLOBAL CONFIGURATION DROP GROUP DROP INDEX
Example -- Delete the foreign data wrapper dbi. gaussdb=# DROP FOREIGN DATA WRAPPER dbi; Helpful Links CREATE FOREIGN DATA WRAPPER and ALTER FOREIGN DATA WRAPPER Parent topic: D
Examples -- Create a package. gaussdb=# CREATE OR REPLACE PACKAGE PCK1 IS a int; END pck1; / CREATE PACKAGE -- Delete the package. gaussdb=# DROP PACKAGE PCK1; DROP PACKAGE Helpful Links ALTER PACKAGE and CREATE PACKAGE Parent topic: D
RESTRICT: refuses to delete the trigger if any objects depend on it. This is the default action. Examples For details, see Examples in CREATE TRIGGER. Helpful Links CREATE TRIGGER, ALTER TRIGGER, and ALTER TABLE Parent topic: SQL Syntax
Example -- Delete the foreign data wrapper dbi. gaussdb=# DROP FOREIGN DATA WRAPPER dbi; Helpful Links ALTER FOREIGN DATA WRAPPER and CREATE FOREIGN DATA WRAPPER Parent topic: SQL Syntax
RESTRICT: refuses to delete the trigger if any objects depend on it. This is the default action. Examples For details, see Examples in CREATE TRIGGER. Helpful Links CREATE TRIGGER, ALTER TRIGGER, and ALTER TABLE Parent topic: SQL Syntax
Example -- Delete the foreign data wrapper dbi. gaussdb=# DROP FOREIGN DATA WRAPPER dbi; Helpful Links ALTER FOREIGN DATA WRAPPER and CREATE FOREIGN DATA WRAPPER Parent topic: SQL Syntax
RESTRICT Refuses to delete the type if any objects depend on it. This is the default action. Examples See Examples in "CREATE TYPE." Helpful Links CREATE TYPE and ALTER TYPE Parent topic: SQL Syntax
In this case, you need to manually delete them.
Step 3: Verify the Upgrade After the upgrade is complete, check the instance status, backup creation status, and instance connectivity, and whether you can add, delete, update, and query data in the instance.
Global temporary tables can be created using ON COMMIT PRESERVE ROWS or ON COMMIT DELETE ROWS.
Executing DELETE will trigger the BEFORE DELETE and AFTER DELETE triggers. The UNIQUE constraint or primary key of DEFERRABLE is not supported.
Value range: Boolean on indicates that non-initial users have the permission to create, modify, and delete directories. off indicates that non-initial users do not have the permission to create, modify, and delete directories.
