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

GAUSS-03821 -- GAUSS-03830

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.