0
Fixed

Postgres migration does not specify schema in DROP INDEX command

Chase Roden 5 years ago updated 5 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:


Image 743

The resulting DROP INDEX command does not work unless the schema is specified:

Image 745
GOOD, I'M SATISFIED
Satisfaction mark by Chase Roden 5 years ago
Under review

Hi,

Thanks for the bug report. We'll fix it ASAP.

Thanks for the quick reply! It looks good except that there's no semicolon after the DROP statement:

Hello,

You are right. Somehow, we forgot about the semicolon.

Please try again.


Adam