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

Clean fails for PROCEDURE #2578

Closed
alextercete opened this issue Nov 28, 2019 · 0 comments
Closed

Clean fails for PROCEDURE #2578

alextercete opened this issue Nov 28, 2019 · 0 comments

Comments

@alextercete
Copy link

Which version and edition of Flyway are you using?

6.1.0

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

CLI

Which database are you using (type & version)?

Postgres 12

Which operating system are you using?

Windows

What did you do?

(Please include the content causing the issue, any relevant configuration settings, the SQL statement that failed (if relevant) and the command you ran.)

flyway migrate followed by flyway clean for the following migration:

CREATE PROCEDURE insert_data(a VARCHAR, b VARCHAR)

LANGUAGE SQL

AS $$

INSERT INTO test_data VALUES (a);

INSERT INTO test_data VALUES (b);

$$;
What did you expect to see?

Clean succeeds.

What did you see instead?

Clean fails with:

org.flywaydb.core.internal.exception.FlywaySqlException: 
Unable to clean schema "public"
-------------------------------
SQL State  : 42809
Error Code : 0
Message    : ERROR: public.insert_data(character varying, character varying) is not a function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant