Migration can only be executed safely on MySQL

[KojoEnch]

Hi, I was searching such a "layout bundle" for a new Symfony project, until I tried to run migrations.

In a nutshell, before I dig into your SQL statements, could you tell us what are the incompatibilities with PostgreSQL ?
Thanks all for the amazing work !

[emodric]

Hi! Some of the migration queries are MySQL specific. We haven't had the chance (or project) to implement pgsql specific ones.

[ilukac]

@KojoEnch we have unit test run against pgsql and all pass. There is also a new project which we are developing with pgsql and so far we dind't experence any problem, but it's still not live. The only thing missing are migrations.

[KojoEnch]

Hey, thanks all for your quick reply ! @ilukac in order to update the schema, I suppose you rewrote the schema dump to pgsql with pgLoader or some other tool then.

[emodric]

Schema is already available for tests, but you can use it on your own: https://github.com/netgen-layouts/layouts-core/blob/master/tests/_fixtures/schema/schema.pgsql.sql

[KojoEnch]

Amazing. Yet I have a short question, I'm gonna opening an issue to keep things clean, and leave you in peace then ;) Thanks again for this great package.