0
Fixed

Postgres migration does not specify schema in DROP INDEX command

Chase Roden 4 months ago • updated 4 months 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:

GOOD, I'M SATISFIED
Satisfaction mark by Chase Roden 4 months 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