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

GAUSS-00351 -- GAUSS-00360

GAUSS-00351: "index '%s' contains expressions"

SQLSTATE: 42809

Description: In the CREATE TABLE ... CONSTRAINT syntax, the index in the PRIMARY KEY or UNIQUE constraint for creating a partitioned table contains an expression.

Solution: Ensure that the index in the PRIMARY KEY or UNIQUE constraint for creating a partitioned table in the CREATE TABLE ... CONSTRAINT syntax does not contain an expression.

GAUSS-00352: "'%s' is a partial index"

SQLSTATE: 42809

Description: The usage is not supported.

Solution: Replace it with a valid index.

GAUSS-00353: "'%s' is a deferrable index"

SQLSTATE: 42809

Description: The usage is not supported.

Solution: Replace it with a valid index.

GAUSS-00354: "index '%s' is not a btree"

SQLSTATE: 42809

Description: The index specified in the B-tree function is not a B-tree index.

Solution: Use the index function that supports the specified index type.

GAUSS-00355: "index '%s' does not have default sorting behavior"

SQLSTATE: 42809

Description: The usage is not supported.

Solution: Replace it with a valid index.

GAUSS-00356: "inherited relation '%s' is not a table"

SQLSTATE: 42809

Description: The table specified in the INHERITS clause in the CREATE TABLE ... INHERITS parent_table syntax is an invalid data table.

Solution: Ensure that the table specified in the INHERITS clause in the CREATE TABLE ... INHERITS parent_table syntax exists.

GAUSS-00357: "column '%s' named in key does not exist"

SQLSTATE: 42703

Description: The column specified by the constraint or INHERITS clause in the CREATE TABLE syntax does not exist in a table.

Solution: Ensure that the column specified by the constraint or INHERITS clause in the CREATE TABLE syntax exists in a table. If the column does not exist, replace the inherited column name or re-create a table.

GAUSS-00358: "column '%s' appears twice in primary key constraint"

SQLSTATE: 42701

Description: Two identical primary keys exist in the UNIQUE constraint specified in the PRIMARY KEY clause in the CREATE TABLE ... CONSTRAINT syntax.

Solution: Check whether two identical primary keys exist in the PRIMARY KEY constraint specified in the PRIMARY KEY clause in the CREATE TABLE ... CONSTRAINT syntax. If yes, change or delete a primary key.

GAUSS-00359: "column '%s' appears twice in unique constraint"

SQLSTATE: 42701

Description: Two identical primary keys exist in the PRIMARY KEY constraint specified in the UNIQE clause in the CREATE TABLE ... CONSTRAINT syntax.

Solution: Check whether two identical primary keys exist in the PRIMARY KEY constraint specified in the UNIQE clause in the CREATE TABLE ... CONSTRAINT syntax. If yes, change or delete a primary key.

GAUSS-00360: "access method 'psort' does not support row store"

SQLSTATE: 0A000

Description: The access method specified in the CREATE INDEX...USING method syntax does not support the row storage table, and the psort index cannot be created.

Solution: Ensure that the access method specified when using the row storage table to create indexes is not the psort type. The psort type applies to the access method for using a column storage table to create indexes. Modify the method to access the index.