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.
Last Article: GAUSS-01371 -- GAUSS-01380
Next Article: GAUSS-01391 -- GAUSS-01400
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.