Postgres migration does not specify schema in DROP INDEX command
Chase Roden hace 4 años • actualizado hace 4 años • 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:
Servicio de atención al cliente por 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.