On this page

Show all

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

GAUSS-00731 -- GAUSS-00740

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

View PDF

GAUSS-00731: "child table '%s' has different type for column '%s'"

SQLSTATE: 42804

Description: When AddColumn is run to add a column to a parent table, this column and a column in the child tables share the same name but have different types.

Solution: Modify the type of the column to be added to that of the child tables.

GAUSS-00732: "child table '%s' has different collation for column '%s'"

SQLSTATE: 42P21

Description: When AddColumn is run to add a column to a parent table, this column and a column in the child tables share the same name but have different collations.

Solution: Modify the collation of the column to be added to that of the child tables.

GAUSS-00733: "child table '%s' has a conflicting '%s' column"

SQLSTATE: 42804

Description: When AddColumn is run to add a column to a parent table, the column does not exist in the child tables.

Solution: Ensure the column to be added to the parent table already exists in the child tables.

GAUSS-00734: "failed to coerce base type to domain"

SQLSTATE: XX000

Description: Type conversion failed.

Solution: Check whether the type definition in the SQL statement is correct.

GAUSS-00735: "column must be added to child tables too"

SQLSTATE: 42P16

Description: When AddColumn is run to add a column to a parent table, the column is not added to the child tables.

Solution: When adding a column to the parent table, add it recursively to the child tables.

GAUSS-00736: "column '%s' of relation '%s' already exists"

SQLSTATE: 42701

Description: When a column is added to a relation table or the name of a column in a relation table is changed, the column name already exists in the relation table.

Solution: Specify the column name again.

GAUSS-00737: "cannot alter system column '%s'"

SQLSTATE: 0A000

Description: When ALTER TABLE ALTER COLUMN DROP is run, the column of a system catalog cannot be modified.

Solution: Cancel this operation.

GAUSS-00738: "column '%s' is in a primary key"

SQLSTATE: 42P16

Description: When ALTER TABLE ALTER COLUMN DROP is run, the primary key of a table cannot be modified.

Solution: Cancel this operation.

GAUSS-00739: "'%s' is not a table, index, or foreign table"

SQLSTATE: 42809

Description: When ALTER TABLE ALTER COLUMN SET STATISTICS is run, the object to be modified is not a common table, index, or foreign table.

Solution: Run this statement when the object is a common table, index, or foreign table, or cancel this operation.

GAUSS-00740: "statistics target %d is too low"

SQLSTATE: 22023

Description: When ALTER TABLE ALTER COLUMN SET STATISTICS is run, the value of a statistics target is excessively small.

Solution: Set a valid value for the statistics target.

Parent topic: GAUSS-00701 -- GAUSS-00800

Previous topic: GAUSS-00721 -- GAUSS-00730

Next topic: GAUSS-00741 -- GAUSS-00750

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