lecaillon / Evolve

Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
https://evolve-db.netlify.com
MIT License
846 stars 112 forks source link

Error: `syntax error at or near "-" at character 30` when running Evolve.Erase() #292

Open shaunsales opened 1 year ago

shaunsales commented 1 year ago

After upgrading to 3.1.0 I get the following error when running Evolve.Erase()

2022-12-22 20:35:47 2022-12-22 13:35:47.609 UTC [93] ERROR:  syntax error at or near "-" at character 30
2022-12-22 20:35:47 2022-12-22 13:35:47.609 UTC [93] STATEMENT:  DROP EXTENSION IF EXISTS uuid-ossp CASCADE

The extension needs to be in quotes;

DROP EXTENSION IF EXISTS "uuid-ossp" CASCADE <- This works

Looks like this might be related to the changes in #253