Trigger Error Codes

This section lists the error codes related to triggers.

Error CodeMessageSuggested Action
0A000Not all nodes are at the correct version to use TriggersNot all nodes are upgraded to the version that supports the triggers.
42P17Object %s cannot be bound to a triggerDo not support creating triggers on replicated tables, views, sequences, temporary tables, or time-series tables.
42P17Trigger %s already exists on table %sA trigger of the same name has already created on the target table.
42601empty trigger nameNo trigger name is specified when renaming a trigger.
42704trigger "%s" does not existFail to parse the target trigger.
3D000unsupported table type: %s in triggerThe table associated with the trigger is not an ordinary relational table.
42P13cannot use OLD in INSERT event triggerThe INSERT trigger does not support the OLD alias.
42P13cannot use NEW in DELETE event triggerThe DELETE trigger does not support the NEW alias.
0A000INSERT ... ON CONFLICT is not supported in trigger definitionThe trigger body does not support the INSERT ... ON CONFLICT statement.
42P13Can't update table %s in trigger because it is already used by statement which invoked this trigger.Do not support operating on tables that are associated with the trigger in the trigger body.
42704trigger "%s" on table "%s" does not existThe target trigger does not exist when renaming the trigger.
42P17trigger "%s" already exists on table "%s"A trigger of the same name has already existed when renaming the trigger.
42P17referenced trigger "trig1" for the given action time and event type does not existThe event and time to create a trigger do not match with those to reference (FOLLOWS or PRECEDES) the trigger.
09000TriggeredActionException: errMsgAn error occurs when performing the trigger body.