On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00801 -- GAUSS-00900/ GAUSS-00831 -- GAUSS-00840

GAUSS-00831 -- GAUSS-00840

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

View PDF

GAUSS-00831: "table is missing column '%s'"

SQLSTATE: 42804

Description: The column does not exist in the table.

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

GAUSS-00832: "table has column '%s' where type requires '%s'"

SQLSTATE: 42804

Description: The column names of tables and types are inconsistent.

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

GAUSS-00833: "table '%s' has different type for column '%s'"

SQLSTATE: 42804

Description: The attributes of tables and types are inconsistent.

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

GAUSS-00834: "table has extra column '%s'"

SQLSTATE: 42804

Description: The table contains redundant columns.

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

GAUSS-00835: "'%s' is not a typed table"

SQLSTATE: 42809

Description: The DROP OF operation is performed on a non-typed table.

Solution: Ensure the table is a typed table.

GAUSS-00836: "Distribution column cannot be dropped"

SQLSTATE: 0A000

Description: The ALTER TABLE statement is used to delete a distribution column.

Solution: Do not use the ALTER TABLE statement to delete a distribution column. Check and modify the ALTER TABLE statement.

GAUSS-00837: "Distribution mode cannot be altered"

SQLSTATE: 0A000

Description: The ALTER TABLE statement is used to modify the distribution mode.

Solution: Do not use the ALTER TABLE statement to modify the distribution mode. Check and modify the ALTER TABLE statement.

GAUSS-00838: "Cannot alter table to distribution incompatible with existing constraints"

SQLSTATE: 0A000

Description: The redistribution of a table is incompatible with the constraints on the table.

Solution: Modify the redistribution to be compatible with the constraints.

GAUSS-00839: "Node list is empty: one node at least is mandatory"

SQLSTATE: 42710

Description: When DELETE NODE LIST is run, the node list to be deleted is empty.

Solution: Check and modify this statement. Run DELETE NODE LIST for non-empty node lists.

GAUSS-00840: "PGXC Node %s: object not in relation node list"

SQLSTATE: 42710

Description: When DELETE NODE LIST is run, the node to be deleted does not exist in a specified node list.

Solution: Check and modify this statement. Run DELETE NODE LIST only for nodes that exist in a specified node list.

Parent topic: GAUSS-00801 -- GAUSS-00900

Previous topic: GAUSS-00821 -- GAUSS-00830

Next topic: GAUSS-00841 -- GAUSS-00850

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