It should just be doing that if you are doing a diff. Just making sure that is what you are doing and it is not making those calls on its own...
I checked and it looks like the call to the 1 = 0 statement is trying to escape the table name and the postgres Database class is coded to quote them correctly. What version of liquibase are you working with? Nathan -----Original Message----- From: Robert Fischer [mailto:robert.fisc...@smokejumperit.com] Sent: Friday, February 13, 2009 8:14 AM To: liquibase-user@lists.sourceforge.net Subject: [Liquibase-user] Dies on "SELECT ID FROM user WHERE 1 = 0" When Liquibase fires up, I'm getting a whole series of "select" statements, including this one: p6spy - 08:59:30|1|1|statement||SELECT ID FROM TAXES WHERE 1 = 0 p6spy - 08:59:30|0|1|statement||SELECT VERSION FROM TAXES WHERE 1 = 0 p6spy - 08:59:30|0|1|statement||SELECT LOCATION FROM TAXES WHERE 1 = 0 p6spy - 08:59:30|0|1|statement||SELECT PERCENT FROM TAXES WHERE 1 = 0 p6spy - 08:59:30|11|1|statement||SELECT ID FROM user WHERE 1 = 0 When the "user" call is hit, the rollback is triggered and then I'm seeing the following: [11695] AutobaseGrailsPlugin Error during Autobase migration liquibase.exception.MigrationFailedException: Migration failed for change set NewRepublic-autobase::RemoveModelNameUsing-model_name-inventory::Robert: Reason: java.sql.SQLException: Table not found in statement [SELECT ID FROM user] at liquibase.ChangeSet.execute(ChangeSet.java:184) at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26) at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) at liquibase.LiquibaseDsl.update(LiquibaseDsl.groovy:93) at liquibase.LiquibaseDsl$update.call(Unknown Source) ~~ Robert Fischer. Grails Training http://GroovyMag.com/training Smokejumper Consulting http://SmokejumperIT.com Enfranchised Mind Blog http://EnfranchisedMind.com/blog Check out my book, "Grails Persistence with GORM and GSQL"! http://www.smokejumperit.com/redirect.html ------------------------------------------------------------------------ ------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user
