检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
SQLSTATE: 42501 Description: Common users are not allowed to delete resource pool objects. Solution: Only system users can delete resource pools. Common users do not have the permission to delete resource pools.
If an object whose name is truncated mistakenly cannot be deleted, delete the object using the name before the truncation, or manually delete it from the corresponding system catalog on each node.
Deleting Resources After performing the steps in "Getting Started", if you do not need to use the sample data, clusters, ECSs, or VPCs, delete the resources so that your service quotas will not be wasted or occupied. Delete a GaussDB(DWS) cluster.
RESTRICT: refuses to delete the view if any objects depend on it. This is the default.
Delete 15 ALTER TABLEPartitioned tableexchange with unloggTable Do not exchange partitioned tables with unlogged tables. Keywords Table 2 Keywords Change Type No.
If an object whose name is truncated mistakenly cannot be deleted, delete the object using the name before the truncation, or manually delete it from the corresponding system catalog on each node. Database names must comply with the naming convention of SQL identifiers.
If an object whose name is truncated mistakenly cannot be deleted, delete the object using the name before the truncation, or manually delete it from the corresponding system catalog on each node. Database names must comply with the naming convention of SQL identifiers.
Execute DROP...CASCADE only when necessary because this operation will delete the text search configuration that uses this dictionary.
RESTRICT: refuses to delete the view if any objects depend on it. This is the default.
Execute DROP...CASCADE only when necessary because this operation will delete the text search configuration that uses this dictionary.
Use either of the following two methods to recreate an index: Run the DROP INDEX statement to delete the index and run the CREATE INDEX statement to create an index. Delete an index. DROP INDEX areaS_idx; DROP INDEX Create an index.
GAUSS-01392: "DELETE trigger's WHEN condition cannot reference NEW values" SQLSTATE: 42P17 Description: New values are quoted in the WHEN clause for DELETE triggers. Solution: Do not quote new values in the WHEN clause for DELETE triggers.
an unconditional ON INSERT DO INSTEAD rule with a RETURNING clause. level:ERROR GS_221100017 errmsg:cannot perform UPDATE RETURNING on relation %s. errhint: You need an unconditional ON UPDATE DO INSTEAD rule with a RETURNING clause. level:ERROR GS_221100018 errmsg:cannot perform DELETE
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 -- Delete all employees in a department from the EMP table. If the department has no employees, delete the department from the DEPT table.
Use either of the following two methods to recreate an index: Run the DROP INDEX statement to delete the index and run the CREATE INDEX statement to create an index. Delete an index. DROP INDEX areaS_idx; DROP INDEX Create an index.
Use either of the following two methods to recreate an index: Run the DROP INDEX statement to delete the index and run the CREATE INDEX statement to create an index. Delete an index. DROP INDEX areaS_idx; DROP INDEX Create an index.
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 -- Delete all employees in a department from the EMP table. If the department has no employees, delete the department from the DEPT table.
Delete the index before the import.
To delete the manual snapshots, log in to the GaussDB(DWS) management console and go to the Clusters page.
Handling Procedure When creating a GDS foreign table, delete the specified distribution information, that is, delete the specified DISTRIBUTE BY ROUNDROBIN in the statement. Parent topic: Data Import and Export
