Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00701 -- GAUSS-00800/ GAUSS-00791 -- GAUSS-00800
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-00791 -- GAUSS-00800

GAUSS-00791: "default for column '%s' cannot be cast automatically to type %s"

SQLSTATE: 42804

Description: When ALTER COLUMN TYPE is run, a default expression cannot be automatically cast to a type.

Solution: Modify this operation.

GAUSS-00792: "cannot alter type of a pinned column"

SQLSTATE: XX000

Description: The type of the column cannot be changed, because other objects depend on it.

Solution: Find and delete the dependency, and then change the column type. To modify a table that a view depends on, save the view definition and delete the view first. Change the data type of the table, and then rebuild the view.

GAUSS-00793: "unexpected object depending on column: %s"

SQLSTATE: XX000

Description: The object of the dependency type does not exist.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00794: "cannot alter type of a column used by a view or rule"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, a view or rule is used to change the type of a column.

Solution: Modify this operation.

GAUSS-00795: "cannot alter type of a column used in a trigger definition"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, the type of a column used in a trigger definition cannot be modified.

Solution: Modify this operation.

GAUSS-00796: "unrecognized object class: %u"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00797: "found unexpected dependency type '%c'"

SQLSTATE: XX000

Description: The dependency type is incorrect.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00798: "found unexpected dependency for column"

SQLSTATE: XX000

Description: The column dependency type is incorrect.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00799: "foreign table '%s' does not exist"

SQLSTATE: 42704

Description: When ALTER COLUMN OPTIONS is run, a foreign table does not exist.

Solution: Modify this operation.

GAUSS-00800: "unexpected statement type: %d"

SQLSTATE: XX000

Description: The type of the table-changing clause is incorrect.

Solution: Check whether the SQL statement is supported.