Updated on 2023-12-22 GMT+08:00

GAUSS-00811 -- GAUSS-00820

GAUSS-00811: "'%s' is not a table, index, or TOAST table"

SQLSTATE: 42809

Description: The object on which the set, reset, replace, or reloptions operation is performed is not a table, index, or a TOAST table.

Solution: Do not perform these operations on objects other than tables, indexes, or TOAST tables.

GAUSS-00812: "can not set tablespace for partition of neither table nor index"

SQLSTATE: 42601

Description: The tablespace is set for the partition of objects other than tables and indexes.

Solution: Do not perform this operation on objects other than tables and indexes.

GAUSS-00813: "cannot have multiple MOVE TABLESPACE subcommands"

SQLSTATE: 42601

Description: Multiple MOVE TABLESPACE sub-commands are run at a time.

Solution: Do not run multiple MOVE TABLESPACE sub-commands at a time.

GAUSS-00814: "can not specify 'PARTITION FOR (value,,,)' when altering partition tablespace for index"

SQLSTATE: XX000

Description: The partition of each column attribute is specified when you change the tablespace partition of an index.

Solution: Do not specify the partition of column attributes when changing the tablespace partition of the index.

GAUSS-00815: "invalid partition node type when altering tablespace for partition"

SQLSTATE: XX000

Description: An invalid partition node is set when you change the tablespace partition.

Solution: Specify a valid partition node for the tablespace.

GAUSS-00816: "cache lookup failed for partition %u"

SQLSTATE: XX000

Description: Failed to find the partition in the cache.

Solution: Replace the original partition with a valid one.

GAUSS-00817: "cannot move system relation '%s'"

SQLSTATE: 0A000

Description: When ALTER TABLE SET TABLESPACE is run, the system catalog cannot be moved.

Solution: Cancel this operation.

GAUSS-00818: "cannot move temporary tables of other sessions"

SQLSTATE: 0A000

Description: When ALTER TABLE SET TABLESPACE is run, tables to be moved are temporary tables of other sessions.

Solution: Cancel this operation.

GAUSS-00819: "cannot change inheritance of typed table"

SQLSTATE: 42809

Description: When ALTER TABLE INHERIT is run, the table to which a parent table is added is a typed table.

Solution: Cancel this operation.

GAUSS-00820: "relation '%s' is a partitioned table"

SQLSTATE: XX000

Description: When ALTER TABLE INHERIT is run, the table to which a parent table is added is a partitioned table.

Solution: Cancel this operation.