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

GAUSS-01281 -- GAUSS-01290

GAUSS-01281: "access method '%s' does not support unique indexes"

SQLSTATE: 0A000

Description: The index mode cannot be used for the unique index.

Solution: Do not create the unique index in the index mode described in the error message.

GAUSS-01282: "access method '%s' does not support multicolumn indexes"

SQLSTATE: 0A000

Description: The index mode cannot be used for the combination index.

Solution: Do not create the unique index in the index mode described in the error message.

GAUSS-01283: "access method '%s' does not support exclusion constraints"

SQLSTATE: 0A000

Description: The index mode cannot be used for exclusion constraints.

Solution: Do not use the index mode described in the error message to add exclusive constraints.

GAUSS-01284: "PrimaryKey/UniqueIndex of distribute table must contain hash distribution column"

SQLSTATE: 0A000

Description: The GaussDB(DWS) primary key constraint takes effect through a unique B-tree index. If the primary key constraint does not contain the distribution key, the index cannot be created.

Solution: Check whether the primary key constraint contains the distribution key.

GAUSS-01285: "unknown constraint type"

SQLSTATE: XX000

Description: The constraint type defined during index creation is incorrect.

Solution: The keyword for creating an index can only be PRIMARY KEY, UNIQUE, or EXCLUDE. Use a one of them to rebuild the index.

GAUSS-01286: "fail to get index info when create index partition"

SQLSTATE: 42P17

Description: The index information fails to be obtained during the creation of a partition index.

Solution: Re-create the partition index. If the system still displays a failure message, an internal error occurs. Contact technical support.

GAUSS-01287: "index partition with name '%s' already exists"

SQLSTATE: 42704

Description: The name of a partitioned index exists.

Solution: Modify the name of a partitioned index to avoid duplication.

GAUSS-01289: "collation '%s' does not exist"

SQLSTATE: 42P17

Description: The sorting mode of indexes does not exist.

Solution: Ensure that the sorting mode of indexes is correct.

Example:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
postgres=# create table t7(c1 int,c2 text)
postgres-# partition by range (c2)(
postgres(# partition p0 values less than ('a'),
postgres(# partition p1 values less than ('b'),
postgres(# partition p2 values less than (maxvalue));
NOTICE:  The 'DISTRIBUTE BY' clause is not specified. Using round-robin as the distribution mode by default.
HINT:  Please use 'DISTRIBUTE BY' clause to specify suitable data distribution column.
CREATE TABLE
postgres=# create unique index t7_idx on t7 (c2 COLLATE "xxxx") local(
postgres(# partition p0,partition p1,partition p2);
ERROR:  collation "xxxx" does not exist

GAUSS-01290: "cannot use subquery in index predicate"

SQLSTATE: 0A000

Description: The subquery cannot be used in the expression index.

Solution: Ensure that no subquery is used in the expression index.