Re: [Liquibase-user] Liquibase 1.9.2 generateChangelog Ant targetiscreating createIndex elements without the column namewhichis required

2009-04-08 Thread Animesh Jain
Hi Nathan Yup this seems to fix it. How can I get to know what you patched, as I feel that is a good way to get acquainted with a new codebase. Animesh On Thu, Apr 9, 2009 at 12:48 AM, Voxland, Nathan < nvoxl...@intelligentinsites.com> wrote: > I uploaded a test version that should fix the pro

Re: [Liquibase-user] Generating idempotent SQL scripts

2009-04-08 Thread Paul Keeble
Gents, I can see why we want it, I fight this battle with clients every week and its not a pretty one. This approach works only when you ignore about 90% of Liquibase's functionality, including ignoring its cross database compatibility. If you build a tool for Oracle or a couple of other Databa

Re: [Liquibase-user] Generating idempotent SQL scripts

2009-04-08 Thread Voxland, Nathan
The way I understand it, you guys are looking for a way to run updateSQL, but not pass it a database connection to check the databasechangelog table of, but instead output all SQL that would be run against an empty databasechangelog tablem with each changeset block having an “if row exists” swit

Re: [Liquibase-user] Generating idempotent SQL scripts

2009-04-08 Thread Ben Wolfe
Excellent point Paul, but I don't want a database agnostic script. I want a mysql specific script to be generated. (or oracle specific, postgres, etc. It should be passed in as a parameter at sql script creation time). Preconditions can be checked via sql, not sure what you mean about var

Re: [Liquibase-user] Liquibase 1.9.2 generateChangelog Ant targetiscreating createIndex elements without the column namewhichis required

2009-04-08 Thread Voxland, Nathan
I uploaded a test version that should fix the problem. Could you double check that it works for you? http://www.liquibase.org/liquibase-SNAPSHOT.jar Nathan From: Animesh Jain [mailto:anim...@itasveer.com] Sent: Wednesday, April 08, 2009 12:41 PM To: liquibase-user@lists.sourceforge.net Su

Re: [Liquibase-user] Generating idempotent SQL scripts

2009-04-08 Thread Ben Wolfe
Having this kind of tooling would be great. There are many users that are running, say, database version 1.4 and want to upgrade to the latest. If they were running our war file things would be fine, but they are just using our database model. Our liquibase xml file has changesets from ver

Re: [Liquibase-user] Liquibase 1.9.2 generateChangelog Ant target iscreating createIndex elements without the column name whichis required

2009-04-08 Thread Animesh Jain
I'm trying on MySQL 5.0.51 on a windows machine Thanks Animesh On Wed, Apr 8, 2009 at 10:05 PM, Voxland, Nathan < nvoxl...@intelligentinsites.com> wrote: > I’ll take a look at it. I think I had ran into it in testing, but > thought it looked database-specific. > > > > What database are you usi

Re: [Liquibase-user] Liquibase 1.9.2 generateChangelog Ant target iscreating createIndex elements without the column name whichis required

2009-04-08 Thread Voxland, Nathan
I'll take a look at it. I think I had ran into it in testing, but thought it looked database-specific. What database are you using? Nathan From: Animesh Jain [mailto:anim...@itasveer.com] Sent: Wednesday, April 08, 2009 8:49 AM To: liquibase-user@lists.sourceforge.net Subject: [Liqu

[Liquibase-user] Generating idempotent SQL scripts

2009-04-08 Thread Thomas Vial
Hi all! I am considering introducing LiquiBase into a project I'm currently working on. After thinking about the process we usually follow wrt staging from development to Q&A and then to production, I feel that a very useful feature would be the ability to update any existing database to the most

[Liquibase-user] Liquibase 1.9.2 generateChangelog Ant target is creating createIndex elements without the column name which is required

2009-04-08 Thread Animesh Jain
I simply created a database with one simple table (user) and then run the generateChangelog command on it Here's what I'm getting http://www.liquibase.org/xml/ns/dbchangelog/1.9"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation=" http://www.liquibase.org/xml/ns/dbchange