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

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 returned value of the trigger function is not a Trigger type.

Solution: Ensure that the returned 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: No result is displayed during the searching for a trigger based on names.

Solution: Specify an existing trigger name.