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

GAUSS-01381 -- GAUSS-01390

GAUSS-01381: "'%s' is a view"

SQLSTATE: 42809

Description: A row-level BEFORE or AFTER trigger or a TRUNCATE trigger is defined on the view.

Solution: Define only the INSTEAD OF trigger on the view.

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

SQLSTATE: 42809

Description: Triggers are defined on objects except 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-01384: "INSTEAD OF triggers must be FOR EACH ROW"

SQLSTATE: 0A000

Description: The INSTEAD OF triggers are defined as FOR EACH STATEMENT.

Solution: Define INSTEAD OF triggers as FOR EACH ROW.

GAUSS-01385: "INSTEAD OF triggers cannot have WHEN conditions"

SQLSTATE: 0A000

Description: The WHEN clause cannot be added for INSTEAD OF triggers.

Solution: Do not add a WHEN clause for 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: The subquery is used in the WHEN clause for triggers.

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

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

SQLSTATE: 42803

Description: The gather function is used in the WHEN clause for triggers.

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

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

SQLSTATE: 42P20

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

Solution: Do not use the 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.