There should be a constraint on the name of the tables and the relations being created

Questions and Answers
1

While creating the relations, Postgres creates trims the table names to a certain limit but during deletion, it doesn’t trim it. This causes the migration code to break.