Hi,
I’m getting the following error during diff on a Postgres databases.
Thanks for your help!
./liquibase --driver=org.postgresql.Driver --defaultSchemaName=schema1 --url=jdbc:postgresql://localhost/db2 --username=user2 diff --referenceUrl=jdbc:postgresql://localhost/db1 --referenceUsername=user1
SEVERE 10/8/11 3:47 PM:liquibase: ERROR: syntax error at or near “table”
Position: 8
liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: syntax error at or near “table”
Position: 8
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:251)
at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(DatabaseSnapshotGeneratorFactory.java:69)
at liquibase.diff.Diff.compare(Diff.java:63)
at liquibase.integration.commandline.CommandLineUtils.doDiff(CommandLineUtils.java:118)
at liquibase.integration.commandline.Main.doMigration(Main.java:713)
at liquibase.integration.commandline.Main.main(Main.java:133)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near “table”
Position: 8
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.isColumnAutoIncrement(JdbcDatabaseSnapshotGenerator.java:842)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns(JdbcDatabaseSnapshotGenerator.java:369)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:244)
… 5 more