sql: add support for NOT VALID Foreign Key constraints

[jseldess]

Jesse Seldess commented:

PR: cockroachdb/cockroach#38663

From release notes:

Added support for NOT VALID option for [Foreign Key constraints](../v19.2/foreign-key.html]. [#38663][#38663) {% comment %}doc{% endcomment %}

Jira Issue: DOC-303

[jseldess]

@lhirata, I'll handle this as part of #5690, since they're connected.

[jseldess]

@ericharmeling, I've had this in progress for months at this point and don't think I can get it done. Is it ok to assign to you? It's not higher priority than 20.1 work.

[vy-ton]

Moving this to the SQL Docs board since I ran into cockroachdb/cockroach#59706 and couldn't check which constraints NOT VALID can be applied to

[jseldess]

This confused someone else: #7730. @ericharmeling, @vy-ton, any chance we can prioritize this? I feel bad that I started it a long time ago and let it drop.

[exalate-issue-sync]

Dikshant Adhikari (dikshant) commented:
Ryan Kuo This continues to confuse folks, including some of our contractors working on third party tooling
https://cockroachlabs.slack.com/archives/C01JBLP0CRX/p1705250875877119

Any chance we could get this in the near future?

[exalate-issue-sync]

Dikshant Adhikari (dikshant) commented:
Shannon Bradshaw
Since this ticket is super old and I just changed the product area to SQL Foundations does it need to be reassigned?

[exalate-issue-sync]

Shannon Bradshaw (shannonbradshaw) commented:
Yes. Done.