Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

GAUSS-03811 -- GAUSS-03820

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

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.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback