检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
RESTRICT: refuses to delete the objects if other objects depend on them. This is the default action. Helpful Links REASSIGN OWNED and DROP ROLE Parent topic: SQL Syntax
If a temporary table is used, delete the temporary table before you return the connection to the connection pool. If you do not do so, the connection state in the connection pool will remain, which affects subsequent operations using the connection pool.
The DBA user, system administrators, or the user who creates the job can delete or modify the job parameters through the remove, change, next_data, what, or interval parameter.
user jack. gaussdb=# DROP USER jack CASCADE; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds; Helpful Links GRANT and REVOKE Parent topic: A
In this way, the sequence will be deleted when you delete its associated column or the table where the column belongs to. The associated table and sequence must be owned by the same user and in the same schema.
Therefore, delete unnecessary indexes periodically. Table 1 Indexing method Indexing Method Description Unique index An index that requires the uniqueness of an index attribute or an attribute group.
If you run VACUUM FULL immediately after running DELETE, the space will not be recycled. After executing DELETE, execute 1000 non-SELECT transactions, or wait for 1s and then execute one transaction. Then, run VACUUM FULL to the space.
If the current database is the one that created a job (that is, dbname in pg_job), you can delete or modify parameter settings of the job using the cancel, update, next_data, content, or interval parameter.
If you run VACUUM FULL immediately after running DELETE, the space will not be recycled. After executing DELETE, execute 1000 non-SELECT transactions, or wait for 1s and then execute one transaction. Then, run VACUUM FULL to the space.
a masking policy. gaussdb=# DROP MASKING POLICY maskpol1, maskpol2, maskpol3, maskpol4, maskpol5, maskpol6, maskpol7, maskpol8; -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL mask_lb1, mask_lb2, mask_lb3, mask_lb4, mask_lb5, mask_lb6, mask_lb7, mask_lb8; -- Delete the
If the current database is the one that created a job, (that is, dbname in pg_job), you can delete or modify parameter settings of the job using the cancel, update, next_data, content, or interval parameter.
Therefore, delete unnecessary indexes periodically. Table 1 Indexing methods Indexing Method Description Unique index An index that requires the uniqueness of an index attribute or an attribute group.
If you run VACUUM FULL immediately after running DELETE, the space will not be recycled. After executing DELETE, execute 1000 non-SELECT transactions, or wait for 1s and then execute one transaction. Then, run VACUUM FULL to the space.
If you run VACUUM FULL immediately after running DELETE, the space will not be reclaimed. After executing DELETE, execute 1000 non-SELECT transactions, or wait for 1s and then execute one transaction. Then, run VACUUM FULL to reclaim the space.
Therefore, delete unnecessary indexes periodically. Table 1 Indexing method Indexing Method Description Unique index An index that requires the uniqueness of an index attribute or an attribute group.
DELETE Enable DELETE. Level: global, database, and table. DROP Allows you to delete databases, tables, or views. Level: global, database, and table. EVENT Enable scheduled tasks. Level: global and database. EXECUTE Allows you to execute stored procedures.
Delete partition P8. 1 2 openGauss=# ALTER TABLE tpcds.web_returns_p2 DROP PARTITION P8; ALTER TABLE Add a partition.
When you delete a PRIMARY KEY constraint by constraint name, the NOT NULL constraint is not deleted. If necessary, manually delete the NOT NULL constraint. When JDBC is used, the DEFAULT value can be set through PrepareStatement.
+------------------ dn_6001_6002_6003 | f dn_6004_6005_6006 | f dn_6007_6008_6009 | f (3 rows) -- Create a node group and replace dn_6001_6002_6003 with the actual node name obtained in the previous step. gaussdb=# CREATE NODE GROUP test_group WITH ( dn_6001_6002_6003 ); -- Delete
Its value is NULL. privilege character varying(40) Permissions on an object, including USAGE, UPDATE, DELETE, INSERT, CONNECT, SELECT, and EXECUTE. grantable character varying(3) Specifies whether the grant contains the GRANT option.
