On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00701 -- GAUSS-00800/ GAUSS-00741 -- GAUSS-00750

GAUSS-00741 -- GAUSS-00750

Updated on 2024-03-15 GMT+08:00

View PDF

GAUSS-00741: "invalid storage type '%s'"

SQLSTATE: 22023

Description: When ALTER TABLE ALTER COLUMN SET STORAGE is run, the target data storage type is invalid.

Solution: Modify the target data storage type to a valid one.

GAUSS-00742: "column data type %s can only have storage PLAIN"

SQLSTATE: 0A000

Description: When ALTER TABLE ALTER COLUMN SET STORAGE is run, the column data storage type is not set to PLAIN.

Solution: Set the column data storage type to PLAIN.

GAUSS-00743: "cannot drop column from typed table"

SQLSTATE: 42809

Description: When ALTER TABLE DROP COLUMN is run, the column of a typed table cannot be deleted.

Solution: Cancel this operation.

GAUSS-00744: "cannot drop partitioning column '%s'"

SQLSTATE: 0A000

Description: When ALTER TABLE DROP COLUMN is run, the column of a partitioned table cannot be deleted.

Solution: Cancel this operation.

GAUSS-00745: "cannot drop system column '%s'"

SQLSTATE: 0A000

Description: When ALTER TABLE DROP COLUMN is run, the column of a system catalog cannot be deleted.

Solution: Cancel this operation.

GAUSS-00746: "cannot drop inherited column '%s'"

SQLSTATE: 42P16

Description: When ALTER TABLE DROP COLUMN is run, the column of an inherited table cannot be deleted.

Solution: Cancel this operation.

GAUSS-00747: "cache lookup failed for attribute '%s' of relation %u"

SQLSTATE: XX000

Description: Failed to find the column.

Solution: Contact technical support.

GAUSS-00748: "relation %u has non-inherited attribute '%s'"

SQLSTATE: XX000

Description: The inherited table does not have the corresponding inherited columns.

Solution: The system is abnormal. Contact technical support.

GAUSS-00749: "index '%s' is not unique"

SQLSTATE: XX000

Description: The index related to the added unique constraint does not have the unique attribute.

Solution: The system is abnormal. Contact technical support.

GAUSS-00750: "constraint '%s' for relation '%s' already exists"

SQLSTATE: 42710

Description: ALTER TABLE ADD CONSTRAINT cannot be run if new constraints already exist.

Solution: Modify the new constraints.

Parent topic: GAUSS-00701 -- GAUSS-00800

Previous topic: GAUSS-00731 -- GAUSS-00740

Next topic: GAUSS-00751 -- GAUSS-00760

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel