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
Please sign in to leave a comment.
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.
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
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.