On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00701 -- GAUSS-00800/ GAUSS-00721 -- GAUSS-00730

GAUSS-00721 -- GAUSS-00730

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

View PDF

GAUSS-00721: "column '%s' contains null values"

SQLSTATE: 23502

Description: Not-null columns contain null values.

Solution: Check for conflicts in not-null constraints.

GAUSS-00722: "check constraint '%s' is violated by some row"

SQLSTATE: 23514

Description: Settings of some rows violate CHECK constraints.

Solution: Check for conflicts in CHECK constraints.

GAUSS-00723: "cannot alter type '%s' because column '%s.%s' uses it"

SQLSTATE: 0A000

Description: The column type cannot be modified, because other columns depend on this column.

Solution: Check whether other columns depend on it. If they do, delete them and then change the column type.

GAUSS-00724: "cannot alter foreign table '%s' because column '%s.%s' uses its row type"

SQLSTATE: 0A000

Description: A foreign table cannot be modified if its row type is being used by a column.

Solution: Check whether other columns depend on it. If they do, delete them and then modify the table.

GAUSS-00725: "cannot alter table '%s' because column '%s.%s' uses its row type"

SQLSTATE: 0A000

Description: A table cannot be modified if its row type is being used by a column.

Solution: Check whether other columns depend on it. If they do, delete them and then modify the table.

GAUSS-00726: "cannot alter type '%s' because it is the type of a typed table"

SQLSTATE: 2BP01

Description: The type of a typed table cannot be modified in this way.

Solution: Use ALTER...CASCADE to modify the typed table.

GAUSS-00727: "type %s is not a composite type"

SQLSTATE: 42809

Description: When CREATE TABLE OF/ALTER TABLE OF is run for a type, the type is not composite.

Solution: Run this statement for a composite type.

GAUSS-00728: "cannot add column to typed table"

SQLSTATE: 42809

Description: Columns are added to a typed table.

Solution: Do not add columns to the typed table.

GAUSS-00729: "type '%s' is not supported in column store"

SQLSTATE: 0A000

Description: Column storage does not support this column type.

Solution: Choose the correct column type and try again.

GAUSS-00730: "default value cannot reference to a column"

SQLSTATE: 42809

Description: A default value cannot be used in a column.

Solution: Check whether the default value is enclosed by a pair of quotation marks.

Parent topic: GAUSS-00701 -- GAUSS-00800

Previous topic: GAUSS-00711 -- GAUSS-00720

Next topic: GAUSS-00731 -- GAUSS-00740

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