Postgres migration does not specify schema in DROP INDEX command
Chase Roden 4 years ago • updated 4 years ago • 5
When I generate a migration that modifies an index in Postgres, the generated SQL does not specify the schema for the index on the DROP statement and therefore fails. In this example I changed WHERE clause on an index:
The resulting DROP INDEX command does not work unless the schema is specified:
Customer support service by UserEcho
Thanks for the bug report. We'll fix it ASAP.
This is fixed now. Please check.
Thanks for the quick reply! It looks good except that there's no semicolon after the DROP statement:
You are right. Somehow, we forgot about the semicolon.
Please try again.