Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-03701 -- GAUSS-03800/ GAUSS-03791 -- GAUSS-03800
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-03791 -- GAUSS-03800

GAUSS-03791: "cannot handle qualified ON SELECT rule"

SQLSTATE: XX000

Description: The rule action does not contain conditions.

Solution: Correct the corresponding primary foreign key constraint.

GAUSS-03792: "cannot handle per-attribute ON SELECT rule"

SQLSTATE: XX000

Description: The rule action must be a table-level action.

Solution: Correct the corresponding primary foreign key constraint.

GAUSS-03793: "unrecognized commandType: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-03794: "infinite recursion detected in rules for relation '%s'"

SQLSTATE: 42P17

Description: Infinite recursion is detected in rules.

Solution: Check the usage of rules.

GAUSS-03795: "DO INSTEAD NOTHING rules are not supported for data-modifying statements in WITH"

SQLSTATE: 0A000

Description: data-modifying statements do not support DO INSTEAD NOTHING rules.

Solution: Check the usage of rules.

GAUSS-03796: "conditional DO INSTEAD rules are not supported for data-modifying statements in WITH"

SQLSTATE: 0A000

Description: data-modifying statements do not support conditional DO INSTEAD NO rules.

Solution: Check the usage of rules.

GAUSS-03797: "DO ALSO rules are not supported for data-modifying statements in WITH"

SQLSTATE: 0A000

Description: data-modifying statements do not support DO ALSO rules.

Solution: Check the usage of rules.

GAUSS-03798: "multi-statement DO INSTEAD rules are not supported for data-modifying statements in WITH"

SQLSTATE: 0A000

Description: data-modifying statements do not support multi-statement DO INSTEAD rules.

Solution: Check the usage of rules.

GAUSS-03799: "cannot perform INSERT RETURNING on relation '%s'"

SQLSTATE: 0A000

Description: An error occurs when the insert returning operation is performed on a table because the INSTEAD rule contains returning while the original statement does not contain returning.

Solution: Use the unconditional ON INSERT DO INSTEAD rule of the statement containing returning.

GAUSS-03800: "cannot perform UPDATE RETURNING on relation '%s'"

SQLSTATE: 0A000

Description: An error occurs when the update returning operation is performed on a table because the INSTEAD rule contains returning while the original statement does not contain returning.

Solution: Use the unconditional ON UPDATE DO INSTEAD rule of the statement containing returning.