On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-03801 -- GAUSS-03900/ GAUSS-03821 -- GAUSS-03830

GAUSS-03821 -- GAUSS-03830

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

View PDF

GAUSS-03821: "could not convert table '%s' to a view because it is a partitioned table"

SQLSTATE: 55000

Description: A partitioned table is converted to a view.

Solution: Ensure that the table to be converted to a view is a non-partitioned table.

GAUSS-03822: "could not convert table '%s' to a view because it is not empty"

SQLSTATE: 55000

Description: A non-empty table is converted to a view.

Solution: Ensure that the table to be converted to a view is an empty table.

GAUSS-03823: "could not convert table '%s' to a view because it has triggers"

SQLSTATE: 55000

Description: The table containing triggers is converted to a view.

Solution: Ensure that the table to be converted to a view does not have triggers.

GAUSS-03824: "could not convert table '%s' to a view because it has indexes"

SQLSTATE: 55000

Description: The table containing indexes is converted to a view.

Solution: Ensure that the table to be converted to a view does not have indexes.

GAUSS-03825: "could not convert table '%s' to a view because it has child tables"

SQLSTATE: 55000

Description: The table containing indexes is converted to a view.

Solution: Ensure that the table to be converted to a view does not have sub-tables.

GAUSS-03826: "cannot have multiple RETURNING lists in a rule"

SQLSTATE: 0A000

Description: Multiple returning lists are contained in a rule.

Solution: Check the number of returning lists.

GAUSS-03827: "RETURNING lists are not supported in conditional rules"

SQLSTATE: 0A000

Description: The returning lists are used in the conditional rules.

Solution: Delete the returning lists.

GAUSS-03828: "RETURNING lists are not supported in non-INSTEAD rules"

SQLSTATE: 0A000

Description: The returning lists are used in the non-INSTEAD rules.

Solution: Delete the returning lists.

GAUSS-03829: "SELECT rule's target list has too many entries"

SQLSTATE: 42P17

Description: The SELECT rules target list has more entries than the required number of columns.

Solution: Check the number of columns and delete the unnecessary columns.

GAUSS-03830: "cannot convert relation containing dropped columns to view"

SQLSTATE: 0A000

Description: The table containing dropped columns is converted to a view.

Solution: Check the structure of the table to be converted to a view.

Parent topic: GAUSS-03801 -- GAUSS-03900

Previous topic: GAUSS-03811 -- GAUSS-03820

Next topic: GAUSS-03831 -- GAUSS-03840

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