In this short blog post I want to show you how easy it is to use Ecto validations together with PostgreSQL unique indexes to validate the uniqueness of an association.

http://blog.praveenperera.com/using-compound-unique-indexes-to-validate-uniqueness-of-ecto-associations