search

xataio / pgroll

PostgreSQL zero-downtime migrations made easy
https://www.xata.io
Apache License 2.0
2.97k stars 54 forks source link

drop_index operation quoting issue #355

Closed kostasb closed 3 months ago

kostasb commented 3 months ago

Drop index has trouble with case sensitive names:

[{
"drop_index": {
    "name": "idx_AREA_CODE"
}
}
]

migration is invalid: index "idx_AREA_CODE" does not exist

It requires escaped quotes to work:

[{
"drop_index": {
    "name": "\"idx_AREA_CODE\""
}
}
]