Import CONSTRAINT

[rene]

Hi,
I’m trying to import my PostgreSQL db.
I have a problem with importing CONSTRAINTs. Here is an example:
´´´
CONSTRAINT “column_name” CHECK ((“options” = ANY (ARRAY[‘OPTION1’, ‘OPTION2’]))),
´´´
It gives me the following error:
Expected “)” but “(” found.

What’s the correct syntax here?

Thanks,
René

[Nguyen_Hoang]

Hi René,

Thank you for reporting the issue.

We currently do not fully support importing Check Constraints syntax in PostgreSQL. You can safely remove the Check Constraints because we do not store the Check Constraints in the DBML yet.

[anthony]

Link to feature request:

Feature Request - CHECK constraint support

Hey! Yesterday I asked in this community how could I do a CHECK constraint in DBML, and @Phuc_Nguyen told me that wasn’t possible at the moment. He also said me that I could suggest it, so that’s why I’m here. CHECK restrictions is something I use commonly, and when I create a database using DBLM, I have to convert the code to MySQL and write by myself the CHECK constraint. While that’s not a big problem, I think it would be really amazing if DBML could have support for it. Thanks for reading…

[smithjones]

Ans: This correct code:
CONSTRAINT “column_name” CHECK (“options” IN (‘OPTION1’, ‘OPTION2’))