检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
A logical cluster administrator has the following more permissions than common users: Create, modify, and delete resource pools in the associated logical cluster.
SQLSTATE: 42501 Description: You have no permission to delete objects owned by users. Solution: Ensure that you have the permission to perform such an operation. GAUSS-00623: "Permission denied to reassign objects."
Solution: contact technical support Before contacting them, locate the data row where the error occurred based on the error context, delete invalid characters, and check whether the problem persists. Parent topic: GAUSS-04201 -- GAUSS-04300
For example, change the duplicate value UA502 to UA509. 1 2 INSERT INTO films VALUES ('UA509', 'Bananas', 105, '1971-07-13', 'Comedy', '82 minutes'); INSERT 0 1 Method 2: Delete the primary key constraint of the table films. 1 2 3 4 ALTER TABLE films DROP CONSTRAINT films_pkey; ALTER
Therefore, you are not advised to frequently delete and update column-store tables in GaussDB(DWS).
For other concurrent SQL operations such as SELECT and DELETE, the error "abort transaction due to concurrent update" may also be reported. Handling Procedure Adjust the execution sequence of service logic and the SQL statements.
Delete Xlog files on the secondary server, and perform failover for the standby server. Parent topic: GAUSS-04401 -- GAUSS-04500
This is a preventive error mechanism.contact technical support GAUSS-03672: "btree_xlog_cleanup: _bt_pagedel failed" SQLSTATE: XX000 Description: Failed to delete the B-tree page. Solution: An internal error occurs.
Solution: If NO SCROLL is explicitly specified, delete it. If the current execution plan is not supported, adjust the execution plan. GAUSS-04200: "unsupported portal strategy: %d" SQLSTATE: XX000 Description: Internal system error.
SQLSTATE: D0011 Description: This table does not support the DELETE operation. Solution:contact technical support GAUSS-04444: "'UPDATE' is not supported by the type of relation." SQLSTATE: D0011 Description: This table does not support the UPDATE operation.
Delete objects from a publication. 1 ALTER PUBLICATION name DROP publication_object [, ...] Replace the current object with a specified object. 1 ALTER PUBLICATION name SET publication_object [, ...] Set publication parameters.
Database administrators can manage (DROP, ALTER, and TRUNCATE) objects of private users but cannot access (INSERT, DELETE, SELECT, UPDATE, COPY, GRANT, REVOKE, and ALTER OWNER) the objects before being authorized. Use the CREATE USER syntax to create a private user.
configuration mapping. 1 2 ALTER TEXT SEARCH CONFIGURATION name ALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]; Change the text search configuration dictionary. 1 2 ALTER TEXT SEARCH CONFIGURATION name ALTER MAPPING REPLACE old_dictionary WITH new_dictionary; Delete
Click Delete Resource Pool on the right. Deleting a resource pool that is associated with a database user is not allowed. To delete the resource pool, you need to first disassociate it from the database user. Click OK.
The permission varies depending on the database object type. database CREATE | CONNECT | TEMPORARY | TEMP ALL PRIVILEGES schema CREATE | USAGE | ALTER | DROP ALL PRIVILEGES table SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | ANALYZE | ANALYSE | VACUUM | ALTER
A logical cluster administrator has the following more permissions than common users: Create, modify, and delete resource pools in the associated logical cluster.
Solution: Delete the unwanted parameter and parameter value and perform the operation again. GAUSS-03619: "invalid value for boolean option '%s': %s" SQLSTATE: XX000 Description: The Boolean type data is invalid.
Solution: Remove the dependency relationship or delete the dependent object. GAUSS-01929: "incorrect use of PIN dependency with %s" SQLSTATE: XX000 Description: Internal system error.
Delete the DFS table and rename the schema again. GAUSS-04649: "COPY_ROACH does not implement in CopySendEndOfRow" SQLSTATE: XX000 Description: Do not use ROACH for COPY TO export. Solution: Do not use ROACH for COPY TO export.
GAUSS-02031 -- GAUSS-02040 GAUSS-02031: "must be system admin or replication role to use replication slots" SQLSTATE: 42501 Description: Only system administrators or replication roles can create or delete replication slots.
