Comments
2 comments
-
Hi @hkelderpxs
Sorry, to hear you're experiencing this issue!
We have the following documentation page which shows how to disable owner/privileges in Postgres: https://documentation.red-gate.com/flyway/database-development-using-flyway-desktop/configuring-comparisons-and-script-generations/filters-ignore-rules/postgresql-and-mysql-filtering
-
As it turns out this does solve the issue.
Still what remains is that again and again you folks keep changing stuff in the behaviour of Flyway that is unexpected. In this case I lost most of the day trying to figure out what caused the problems I ran into.
I would strongly suggest including release notes where these kinds of behavioural changes are announced.
Add comment
Please sign in to leave a comment.
Since release 7.1.0 Flyway / Postgresql adds OWNER statements.
e.g. ALTER PROCEDURE inp2.prc_purge_database() OWNER TO admin;
This breaks our deployment since the OWNER differs per target machine.
In previous releases no OWNER was set.
I am unable to find a previous 7.x version and the 6.8 version cannot be used due to changes in the project format.
Is there a setting to disable this new behavior?