Drew Kimball
Drew Kimball
Postgres allows "event" triggers to be defined to execute a trigger function when certain schema changes happen within the database. See the Postgres docs here: https://www.postgresql.org/docs/16/event-trigger-definition.html Oracle has a similar...
This issue tracks adding support for INSTEAD OF triggers to CRDB. INSTEAD OF triggers only operate on views, and completely replace the original mutation operation. They can only be row-level...
This issue tracks adding support for statement level BEFORE and AFTER triggers, which execute the trigger function exactly once. Just as for row-level triggers, statement-level BEFORE triggers execute the function...
This issue tracks adding support for row-level AFTER triggers, which execute for each mutated row in an INSERT, UPDATE, UPSERT, or DELETE after the mutation occurs, as well as any...
This issue tracks adding support for row-level BEFORE triggers, which execute for each mutated row in an INSERT, UPDATE, UPSERT, or DELETE before the mutation occurs. Example: ``` CREATE TRIGGER...
This issue tracks adding support for creating and dropping a trigger on a table. This work will require updating function descriptors for trigger functions so that the function cannot be...
Triggers are used to execute trigger functions, which are UDFs defined with the special `RETURNS TRIGGER` syntax. This issue tracks adding support for trigger functions (not triggers). See the Postgres...
This issue tracks adding support for the TRIGGER datatype, which is used as the return type of a trigger function. TRIGGER is not valid in any other context (e.g. casts,...
This commit sets the `transaction_rows_written_err` guardrail for the `TestExplainRedactDDL` test, since we saw a timeout where a transaction had written 10k rows. Fixes #129810 Release note: None
The type of a RECORD-returning UDF is not fully resolved until after it is fully built within the optbuilder. Therefore, a VALUES expression with a UDF can only determine its...