Postgres database migration failed : permission denied for schema public

[jgarec]

Hello,

We have a critical issue when trying to upgrade from 9.4.0 to latest version.

We are using postgres to persist data and we use a dedicated schema.
We are in a situation where we are not allowed to deploy objects in "public" schema.

Is there any reason why you choose to deploy this materialized view (org_libyears_mv) into public instead of the default schema for the current user ?

I think script 0016 won't work in our case "public" is used for reason_enum whereas it was deployed in another schema

Regards,
Jérôme

[jgarec]

With a sed to remove all occurrences of "public". in /usr/src/mend/core/lib/model/postgres/drizzle-postgres/migrations/*.sql sounds ok