The application allows to create two indexes with the same name
Marek Berkan 8 years ago • updated by mark leavesley 8 years ago • 11
A model validator doesn't check if index name is unique within model. I created two indexes with name "book_fk" in two different tables and a SQL script failed in PostgreSQL database:
SQLState:42P07IMO it should be validated by the application.
ERROR: relation "book_fk" already exists
I turned out that it's specific for MySQL that keys' names may be duplicated within a database. It has been already fixed.
Customer support service by UserEcho
It looks like database specific issue, because PostgreSQL which I use report duplicated indexes names as problems. If MySQL didn't report problems, Vertabelo would check it depending on selected target DB.