On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00301 -- GAUSS-00400/ GAUSS-00321 -- GAUSS-00330

GAUSS-00321 -- GAUSS-00330

Updated on 2024-03-15 GMT+08:00

View PDF

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.

Parent topic: GAUSS-00301 -- GAUSS-00400

Previous topic: GAUSS-00311 -- GAUSS-00320

Next topic: GAUSS-00331 -- GAUSS-00340

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel