PostgreSQL 12 now supports executing ALTER TYPE ... ADD VALUE within a transaction

[axelfontaine]

Which version and edition of Flyway are you using?

Flyway Community Edition 6.5.7

If this is not the latest version, can you reproduce the issue with the latest one as well?

Latest source code on GitHub indicates this hasn't changed.

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Gradle plugin

Which database are you using (type & version)?

PostgreSQL 12

Which operating system are you using?

Windows 10 x64

What did you do?

Execute a migration containing the following statement: ALTER TYPE line_format ADD VALUE 'csv'; with flyway.mixed set to false

What did you expect to see?

Migration succeeds. See https://www.postgresql.org/docs/12/sql-altertype.html#id-1.9.3.42.7

What did you see instead?

Error occurred while executing flywayMigrate
Detected both transactional and non-transactional statements within the same migration (even though mixed is false). Offending statement found at line 9: ALTER TYPE line_format ADD VALUE 'csv' [non-transactional]