cockroachdb / cockroachdb/cockroach
sql: implement triggers that fire for TRUNCATE events
Open
A-sql-pgcompat
A-sql-trigger
C-enhancement
docs-known-limitation
T-sql-queries
X-anchored-telemetry
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
In Postgres, it is possible to define a statement-level trigger that fires when the table is truncated. For example:
```
CREATE TRIGGER t AFTER TRUNCATE ON xy FOR EACH STATEMENT EXECUTE FUNCTION f();
```
This issue tracks adding support for this feature.
Epic: [CRDB-347](https://cockroachlabs.atlassian.net/browse/CRDB-347)
Jira issue: CRDB-44667
Epic CRDB-347
Contributor guide
Assessment
This issue has not been assessed yet.