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

GAUSS-03811 -- GAUSS-03820

GAUSS-03811: "rule '%s' for relation '%s' already exists"

SQLSTATE: 42710

Description: The rule for inserting a table exists.

Solution: Do not insert the rule if it already exists.

GAUSS-03812: "rule actions on OLD are not implemented"

SQLSTATE: 0A000

Description: The rule for the OLD value is not implemented.

Solution: Use a view or trigger to avoid the problem.

GAUSS-03813: "rule actions on NEW are not implemented"

SQLSTATE: 0A000

Description: The rule for the NEW value is not implemented.

Solution: Use a trigger to avoid the problem.

GAUSS-03814: "INSTEAD NOTHING rules on SELECT are not implemented"

SQLSTATE: 0A000

Description: INSTEAD NOTHING rule ON SELECT is not supported.

Solution: Check the usage of rules.

GAUSS-03815: "multiple actions for rules on SELECT are not implemented"

SQLSTATE: 0A000

Description: The rule has more than one action.

Solution: Simplify the rule actions and retain only one.

GAUSS-03816: "rules on SELECT must have action INSTEAD SELECT"

SQLSTATE: 0A000

Description: The rule action is not INSTEAD SELECT.

Solution: Correct the defined rule action.

GAUSS-03817: "rules on SELECT must not contain data-modifying statements in WITH"

SQLSTATE: 0A000

Description: The required rule action cannot contain data modification operations in the WITH statement.

Solution: Correct the defined rule action.

GAUSS-03818: "event qualifications are not implemented for rules on SELECT"

SQLSTATE: 0A000

Description: The execution of rule actions cannot be restricted by conditions.

Solution: Correct the defined rule action.

GAUSS-03819: "'%s' is already a view"

SQLSTATE: 55000

Description: A view can have only the ON SELECT rule action.

Solution: Correct the defined rule action.

GAUSS-03820: "view rule for '%s' must be named '%s'"

SQLSTATE: 42P17

Description: The rule action of a view must be defined as _RETURN.

Solution: Correct the defined rule action.