liquibase: ERROR: syntax error at or near "table"

General Discussion
1

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


2

If you add --logLevel=DEBUG to the command line, do you get more information? Especially the query being executed?

Nathan