On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-03701 -- GAUSS-03800/ GAUSS-03791 -- GAUSS-03800

GAUSS-03791 -- GAUSS-03800

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

View PDF

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.

Parent topic: GAUSS-03701 -- GAUSS-03800

Previous topic: GAUSS-03781 -- GAUSS-03790

Next topic: GAUSS-03801 -- GAUSS-03900

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

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback