The trouble is that not all databases return really useful comments for tables, so we didn't want to automatically move them along to the new database. For example, the comments for mysql tables are usually something like "InnoDB FREE 53k". It is something that we would like to work around and get better integrated, but have not gotten to yet.
What you need to do is change the generated xml from putting them in <comment> tags to <remarks> tags on createTable and they should go into the database comments metadata. Nathan -----Original Message----- From: Evan [mailto:ev...@michevan.id.au] Sent: Tuesday, April 28, 2009 12:02 AM To: liquibase-user@lists.sourceforge.net Subject: [Liquibase-user] Remarks => COMMENT statements? Hi. Just started looking at liquibase and managed to create a changeset for my existing (postgresql) database quite easily. I was impressed that it even picked the comments I had against tables and columns and included them as remarks attributes in the XML. However, when I try updating to a new database, it does not create COMMENT SQL statements when creating the tables, etc. Am I missing something I should be doing to get it to create these? It would be a real boon as it is very convenient when looking at schemas in pgAdmin you see the commented SQL. Thanks. Evan ------------------------------------------------------------------------ ------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user
