Skip to content
This repository has been archived by the owner on Apr 1, 2023. It is now read-only.

Add foreignKey constraint validation in PG session when creating a table #276

Open
johnfangAFW opened this issue Jun 17, 2021 · 0 comments
Milestone

Comments

@johnfangAFW
Copy link
Contributor

As observed in issue: #270, we didn't validate the foreign key constraint properly in pg session. We need to add the support when creating a table so that we could fail the second table creation for the following example:

CREATE TABLE PKTABLE (ptest1 int, ptest2 int, UNIQUE(ptest1, ptest2));
CREATE TABLE FKTABLE_FAIL1 (ftest1 int REFERENCES pktable(ptest1));

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants