doctrine:migration:diff on a postgresql database generate "CREATE SCHEMA public" on the down method

[josensanchez]

I'm not using the public schema, so every table is in others schemas.
i.e:

app.fos_user
data.somtable
gis.postgis_tables

but it doesn't mean that the schema public does not exist. It exist already.

performing the doctrine:migration:diff generate the creation of the public schema

this happens even with the database up to date: It generate an empty up method and only

$this->addSql('CREATE SCHEMA public');

in the down method.

probably it's a doctrine issue and most probably is that it's related to

doctrine/orm#4777

but it's supposed to be solved. Before reopen it I want to be sure that its not related to this project.

I'm using doctrine-migrations 1.1.1 for symfony 3.0

[chrisguitarguy]

This is an issue with DBAL's Schema API, not the ORM. That's why that issue was closed -- without any feedback on where it was a bug :(

Looks like it's still a bug in DBAL (not in migrations itself) doctrine/dbal#1110

[mikeSimonson]

It is indeed a DBAL issue.

Thanks @chrisguitarguy @josensanchez