Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00301 -- GAUSS-00400/ GAUSS-00321 -- GAUSS-00330
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-00321 -- GAUSS-00330

GAUSS-00321: "column exclusion constraints are not supported"

SQLSTATE: XX000

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00322: "unrecognized constraint type: %d"

SQLSTATE: XX004

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00323: "invalid context for constraint type %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00324: "'%s' is not a table, view, composite type, or foreign table"

SQLSTATE: 42809

Description: source_table in the LIKE clause in the CREATE TABLE ... LIKE source_table syntax is not a relational table, view table, composite table, or foreign table.

Solution: Ensure that source_table in the LIKE clause in the CREATE TABLE ... LIKE source_table syntax must be a relational table, view table, composite table, or foreign table.

GAUSS-00325: "could not specify 'INCLUDING PARTITION' for non-partitioned-table relation:'%s'"

SQLSTATE: 42809

Description: INCLUDING PARTITION is incorrectly specified for the partitioned table in the CREATE TABLE ... LIKE source_table syntax.

Solution: Do not specify INCLUDING PARTITION for the partitioned table in the CREATE TABLE ... LIKE source_table syntax.

GAUSS-00326: "could not specify 2 or more 'INCLUDING PARTITION' clauses, only one is allowed"

SQLSTATE: 42809

Description: More than one LIKE...INCLUDING PARTITION clause is specified in the CREATE TABLE ... (LIKE source_table INCLUDING PARTITION) syntax.

Solution: Ensure that only one LIKE...INCLUDING PARTITION clause is specified in the CREATE TABLE ... (LIKE source_table INCLUDING PARTITION) syntax.

GAUSS-00327: "could not specify 2 or more 'INCLUDING RELOPTIONS' clauses, only one is allowed"

SQLSTATE: 42809

Description: More than one INCLUDINGRELOPTIONS is specified in the LIKE clause of the CREATE TABLE ... LIKE source_table syntax.

Solution: Ensure that only one INCLUDINGRELOPTIONS is specified in the LIKE clause of the CREATE TABLE ... LIKE source_table syntax.

GAUSS-00328: "could not specify 2 or more 'INCLUDING DISTRIBUTION' clauses, only one is allowed"

SQLSTATE: 42809

Description: More than one INCLUDINGDISTRIBUTION is specified in the LIKE clause of the CREATE TABLE ... LIKE source_table syntax.

Solution: Ensure that only one INCLUDINGDISTRIBUTION is specified in the LIKE clause of the CREATE TABLE ... LIKE source_table syntax.

GAUSS-00329: "Postgres-XC does not support VIEW in LIKE clauses"

SQLSTATE: 0A000

Description: The view cannot be used in the LIKE clause of the CREATE TABLE ... LIKE syntax.

Solution: Modify the LIKE clause of the CREATE TABLE ... LIKE syntax and delete the view.

GAUSS-00330: "cannot convert whole-row table reference"

SQLSTATE: 0A000

Description: The syntax is not supported.

Solution: Modify the SQL statement.