Phinx cannot create indexes concurrently for postgres databases

[gr1ev0us]

There is no way to perform query which create index concurrently because phinx runs queries in transaction.
So migration have to has option to performs without transaction. For example, check this option in Phinx\Migration\Manager\Environment::executeMigration

[lorenzo]

Maybe indexes should be done outside of the transaction instead?

[gr1ev0us]

Sure. And phinx has to provide ability to do this.

[matejstrasek]

Is there any workaround for this by now?

[rquadling]

You could just commit the transaction early.

$this->getAdapter()->commitTransaction();
\\ Now build your index.

If you do this a lot, then create an abstract migration class and / or a template that does this for you.

Though, probably, doing it on a case-by-case basis will be what I'd prefer.

[othercorey]

Closing due to lack of activity or out of scope. If there is new interest, please open a PR.