cockroachdb / cockroachdb/cockroach
sql: support SET CONSTRAINTS within a transaction
Open
C-enhancement
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
As a subset of https://github.com/cockroachdb/cockroach/issues/158886 / https://github.com/cockroachdb/cockroach/issues/31632 we should implement the [SET CONSTRAINTS](https://www.postgresql.org/docs/current/sql-set-constraints.html) functionality to control deferred FK checks within a transaction. This will require some per-transaction state to keep track of which constraints are deferred and which are immediate.
(This might benefit https://github.com/cockroachdb/cockroach/issues/19444.)
Jira issue: CRDB-67829
Contributor guide
Assessment
This issue has not been assessed yet.