IntelliJ 13.x can't see constraints in a postgres database?

Hi all,

I got really excited about IntelliJ's database tool, combined with the UML modeller and a SQL export ('copy DDL') - but i was a bit surprised to find that the database tool appears to be unable to see any of the constraints in my postgres database, or is ignoring them - am i missing a simple configuration option somewhere or is this missing from the feature set?

Thanks,

Henri

3 comments

Hello.

Constraints are seen in the tree view (e.g. primary key constraint) and in generated DDL. Could you specify what are you missing exactly?

Thank you,
Alexander.

0

Hi Alex,

I've got quite a lot of check constraints (e.g. field must be >0 characters in length) that i can't see. I can see primary and foreign key constraints fine

0

I've checked it - yes, you're right. This is a known limitation: http://youtrack.jetbrains.com/issue/IDEA-58688

Welcome to vote and comment. I will add the reference to this post.

Regards,
Alexander.

0

Please sign in to leave a comment.