GAUSS-01381 -- GAUSS-01390

GAUSS-01381: “'%s' is a view”

SQLSTATE: 42809

Description: Row-level BEFORE, AFTER trigger, or TRUNCATE triggers are defined on views.

Solution: Define only INSTEAD OF triggers on views.

GAUSS-01382: “'%s' is not a table or view”

SQLSTATE: 42809

Description: Triggers are not defined on tables and views.

Solution: Define triggers only on tables and views.

GAUSS-01383: “TRUNCATE FOR EACH ROW triggers are not supported”

SQLSTATE: 0A000

Description: Row-level TRUNCATE triggers are defined.

Solution: Do not define row-level TRUNCATE triggers.

GAUSS-01385: “INSTEAD OF triggers cannot have WHEN conditions”

SQLSTATE: 0A000

Description: WHEN clauses are added to INSTEAD OF triggers.

Solution: Do not add WHEN clauses to INSTEAD OF triggers.

GAUSS-01386: “INSTEAD OF triggers cannot have column lists”

SQLSTATE: 0A000

Description: INSTEAD OF triggers are defined on the columns of tables.

Solution: Do not define INSTEAD OF triggers on the columns of tables.

GAUSS-01387: “cannot use subquery in trigger WHEN condition”

SQLSTATE: 0A000

Description: A subquery is used in the WHEN clause for triggers.

Solution: Do not use a subquery in the WHEN clause for triggers.

GAUSS-01388: “cannot use aggregate function in trigger WHEN condition”

SQLSTATE: 42803

Description: An aggregate function is used in the WHEN clause for triggers.

Solution: Do not use an aggregate function in the WHEN clause for triggers.

GAUSS-01389: “cannot use window function in trigger WHEN condition”

SQLSTATE: 42P20

Description: A window function is used in the WHEN clause for triggers.

Solution: Do not use a window function in the WHEN clause for triggers.

GAUSS-01390: “statement trigger's WHEN condition cannot reference column values”

SQLSTATE: 42P17

Description: Column values are quoted in the WHEN clause for statement triggers.

Solution: Do not quote column values in the WHEN clause for statement triggers.