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

GAUSS-00831 -- GAUSS-00840

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.