Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PostgreSQL Collations are not cleaned up on clean #3786

Open
Mihitoko opened this issue Nov 3, 2023 · 1 comment · May be fixed by #3791
Open

PostgreSQL Collations are not cleaned up on clean #3786

Mihitoko opened this issue Nov 3, 2023 · 1 comment · May be fixed by #3791

Comments

@Mihitoko
Copy link

Mihitoko commented Nov 3, 2023

Which version and edition of Flyway are you using?

We currently use version 9.22.0

If this is not the latest version, can you reproduce the issue with the latest one as well? (Many bugs are fixed in newer releases and upgrading will often resolve the issue)

I also tried it on 10.0.0 (i used the command line since flyway is currently broken with spring boot) but still same issue

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

We use the Java Api together with spring boot

Which database are you using? (Type & version)

Postgresql 13

Which operating system are you using?

MacOS / Debian

What did you do? (Please include the content causing the issue, any relevant configuration settings, the SQL statement(s) that failed (if any), and the command you ran)

I first created a migration which creates a collation.

CREATE COLLATION german (provider = icu, locale = 'de-DE');

And applied it

Then I ran flyway with these command line arguments:
clean -url="jdbc:postgresql://localhost:5432/test" -user=postgres -cleanDisabled=false

What did you expect to see?

I expected that the collations are cleaned up after the clean command was run.

What did you see instead?

The collations where still persisted in the schema

@Mihitoko
Copy link
Author

Mihitoko commented Nov 3, 2023

I would also start working on a fix 😃

Mihitoko added a commit to Mihitoko/flyway that referenced this issue Nov 3, 2023
@Mihitoko Mihitoko linked a pull request Nov 8, 2023 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant