Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] Suppress FK and check constraint checking for existing tables #5341

Open
ndeodhar opened this issue Aug 7, 2020 · 0 comments
Open
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue
Projects

Comments

@ndeodhar
Copy link
Contributor

ndeodhar commented Aug 7, 2020

Jira Link: DB-1754
Today, we don't support consistent checking of FK and check constraints when they are added to a table (via ALTER TABLE).
However, postgres code still runs this check and this can fail / cause OOM issues for large tables. We should suppress this check (in the postgres code) for now.

Note that we'll enable checking of constraints for existing data as part of #1395 (#4192).

@ndeodhar ndeodhar added the area/ysql Yugabyte SQL (YSQL) label Aug 7, 2020
@ndeodhar ndeodhar added this to Backlog in YSQL via automation Aug 7, 2020
@ndeodhar ndeodhar moved this from Backlog to To do in YSQL Aug 7, 2020
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue
Projects
Status: No status
YSQL
  
To do
Development

No branches or pull requests

3 participants