1. Vertabelo
  2. Błędy
0
Naprawione

Postgres migration does not specify schema in DROP INDEX command

Chase Roden 5 lat temu • zaktualizowano 5 lat temu • 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
DOBRZE, JESTEM ZADOWOLONY.
Symbol zadowolenia
Znak zadowolenia przez Chase Roden 5 lat temu
W trakcie analizy
Rafał Strzaliński (Senior Engineer) 5 lat temu

Hi,

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

Naprawione
Rafał Strzaliński (Senior Engineer) 5 lat temu

Hi,

This is fixed now. Please check.

Chase Roden 5 lat temu

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

Adam Mościcki 5 lat temu

Hello,

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

Please try again.


Adam

Chase Roden 5 lat temu

Perfect, thanks!

Customer support service by UserEcho