Help Center> Data Warehouse Service> Error Code Reference> Tenant Plane Error Code Reference> GAUSS-00301 -- GAUSS-00400> GAUSS-00341 -- GAUSS-00350
View PDF

GAUSS-00341 -- GAUSS-00350

GAUSS-00341: "cache lookup failed for opclass %u"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00342: "Partitioned table does not support EXCLUDE index"

SQLSTATE: 0A000

Description: The exclusion constraint cannot be specified for creating a partitioned table in the CREATE TABLE ... CONSTRAINT syntax.

Solution: Modify the CREATE TABLE ... CONSTRAINT syntax, and specify other constraints when creating a partitioned table.

GAUSS-00343: "Invalid PRIMARY KEY/UNIQUE constraint for partitioned table"

SQLSTATE: 0A000

Description: In the CREATE TABLE ... CONSTRAINT syntax, the partition key field name for the partitioned table is not contained in the PRIMARY KEY or UNIQUE constraint for creating a partitioned table.

Solution: Ensure that the partition key field name for the partitioned table is contained in the PRIMARY KEY or UNIQUE constraint for creating a partitioned table in the CREATE TABLE ... CONSTRAINT syntax.

GAUSS-00344: "multiple primary keys for table '%s' are not allowed"

SQLSTATE: 42P16

Description: More than one primary key for INCLUDING INDEXES is specified in the LIKE clause of the CREATE TABLE ... LIKE source_table syntax.

Solution: Ensure that only one primary key for INCLUDING INDEXES is specified in the LIKE clause of the CREATE TABLE ... LIKE source_table syntax.

GAUSS-00345: "cannot use an existing index in CREATE TABLE"

SQLSTATE: 0A000

Description: A constraint is incorrectly specified for the index field in the CREATE TABLE syntax.

Solution: Add a new constraint to the data table using the ALTER TABLE ... ADD table_constraint syntax.

GAUSS-00346: "index '%s' does not exist"

SQLSTATE: 42704

Description: The attribute name for specifying constraints in the CREATE/ALTER TABLE syntax does not exist in the relational table.

Solution: Ensure that the attribute name for specifying constraints in the CREATE/ALTER TABLE syntax exists in the relational table.

GAUSS-00347: "index '%s' is already associated with a constraint"

SQLSTATE: 55000

Description: The usage is not supported.

Solution: Create another index.

GAUSS-00348: "index '%s' does not belong to table '%s'"

SQLSTATE: 55000

Description: The attribute name for specifying constraints in the CREATE/ALTER TABLE table_name syntax does not exist in table_name.

Solution: Ensure that the attribute name for specifying constraints in the CREATE/ALTER TABLE syntax exists in the relational table.

GAUSS-00349: "index '%s' is not valid"

SQLSTATE: 55000

Description: The attribute name for specifying constraints in the CREATE/ALTER TABLE syntax is invalid.

Solution: Ensure that the attribute name for specifying constraints in the CREATE TABLE or ALTER TABLE syntax exists in the relational or schema table.

GAUSS-00350: "'%s' is not a unique index"

SQLSTATE: 42809

Description: In the CREATE TABLE ... CONSTRAINT syntax, the index in the PRIMARY KEY or UNIQUE constraint for creating a partitioned table is not unique.

Solution: Ensure that the index in the PRIMARY KEY or UNIQUE constraint for creating a partitioned table in the CREATE TABLE ... CONSTRAINT syntax is unique.