检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
This variable is NULL for DELETE operations. OLD Old tuple for UPDATE/DELETE operations. This variable is NULL for INSERT operations.
This variable is NULL for DELETE operations. OLD Old tuple for UPDATE/DELETE operations. This variable is NULL for INSERT operations.
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: Deletes objects (such as columns, functions, and operators) that depend on the type. RESTRICT: Refuses to delete the type if any objects depend on it.
If command is set to DELETE, only tuple data that meets the condition (the return value of using_expression is TRUE) can be deleted. The operations that are affected include DELETE and DELETE ... RETURNING.
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.
An existing table having a trigger CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: Deletes objects that depend on the trigger. RESTRICT: Refuses to delete the trigger if any objects depend on it.
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: automatically deletes all objects that are contained in the schema to be deleted. RESTRICT: refuses to delete the schema that contains any objects.
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 text search configuration if any objects depend on it. This is the default. This is the default.
Execute DROP...CASCADE only when necessary because this operation will delete the text search configuration that uses this dictionary.
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.
Examples Delete the myView view: 1 DROP VIEW myView; Delete the customer_details_view_v2 view: 1 DROP VIEW public.customer_details_view_v2; Links ALTER VIEW, CREATE VIEW Parent Topic: DDL Syntax
RESTRICT: refuses to delete the foreign table if any objects depend on it. This is the default behaviour.
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.
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.
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.
