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
Comment actions Permalink

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
Comment actions Permalink

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
Comment actions Permalink

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.