Devskiller / jpa2ddl

JPA Schema Generator Plugin
Apache License 2.0
109 stars 33 forks source link

PostgreSQL Support #13

Closed miguelocarvajal closed 6 years ago

miguelocarvajal commented 6 years ago

Tried using this with PostgreSQL but I get the following error:

[ERROR] Failed to execute goal com.devskiller.jpa2ddl:jpa2ddl-maven-plugin:0.9.5:generate (default-cli) on project cci-data: Unable to build DatabaseInformation: Table "PG_CLASS" not found; SQL statement:
[ERROR] select relname from pg_class where relkind='S' [42102-196]

Using the org.hibernate.dialect.PostgreSQLDialect, if I switch it to org.hibernate.dialect.MySQL57Dialect (as in the example), I do not get this error.

Is there a workaround for this issue?

Thanks!

shexiaogui commented 6 years ago

got the same error when using postgresql

jkubrynski commented 6 years ago

It works OK with CREATE mode, the problem is only in UPDATE. We're trying to overcome lack of PG_TABLE

jkubrynski commented 6 years ago

Released in 0.9.9