GAUSS-01391 -- GAUSS-01400

GAUSS-01391: “INSERT trigger's WHEN condition cannot reference OLD values”

SQLSTATE: 42P17

Description: Old values are quoted in the WHEN clause for INSERT triggers.

Solution: Do not quote old values in the WHEN clause for INSERT triggers.

GAUSS-01392: “DELETE trigger's WHEN condition cannot reference NEW values”

SQLSTATE: 42P17

Description: New values are quoted in the WHEN clause for DELETE triggers.

Solution: Do not quote new values in the WHEN clause for DELETE triggers.

GAUSS-01393: “BEFORE trigger's WHEN condition cannot reference NEW system columns”

SQLSTATE: 0A000

Description: New system column values are quoted in the WHEN clause for BEFORE triggers.

Solution: Do not quote new system column values in the WHEN clause for BEFORE triggers.

GAUSS-01394: “trigger WHEN condition cannot contain references to other relations”

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01395: “function %s must return type 'trigger'”

SQLSTATE: 42P17

Description: The return value of the trigger function is not a trigger type.

Solution: Ensure that the return value of the trigger function is a trigger type.

GAUSS-01396: “trigger '%s' for relation '%s' already exists”

SQLSTATE: 42710

Description: The trigger with the same name is defined on the relational table.

Solution: Modify the trigger name so that it is different from the existing one.

GAUSS-01397: “confused about RI update function”

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01398: “confused about RI delete function”

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01399: “could not find tuple for trigger %u”

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01400: “trigger '%s' for table '%s' does not exist”

SQLSTATE: 42704

Description: Failed to find a trigger by name.

Solution: Specify an existing trigger name.

Feedback
编组 3备份
    openGauss 2024-04-23 00:46:19
    cancel