New Topic: addForeignKeyConstraint dropped and recreated identically in diff'ed changelog

[Nathan Voxland-3]

A new topic, 'addForeignKeyConstraint dropped and recreated identically in diff'ed changelog', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=180.new#new

The text of the topic is shown below:

ChangeLog #1 - Liquibase-generated initial changelog based on schema from products last release:
Code:
    ...
    <changeSet author="Jamie Bisotti (generated)" id="1254319808150-24">
        <addForeignKeyConstraint baseColumnNames="JOB_NAME, JOB_GROUP" baseTableName="QRTZ_JOB_LISTENERS" constraintName="FK_QRTZ_JOB_LST_1" deferrable="false" initiallyDeferred="false" referencedColumnNames="JOB_NAME, JOB_GROUP" referencedTableName="QRTZ_JOB_DETAILS"/>
    </changeSet>
    ...

ChangeLog #2 - Liquibase-generated delta changelog of the schema from the products last release diff'ed against the current schema:
Code:
    ...
    <changeSet author="Jamie Bisotti (generated)" id="1254324457259-9">
        <dropForeignKeyConstraint baseTableName="QRTZ_JOB_LISTENERS" constraintName="FK_QRTZ_JOB_LST_1"/>
    </changeSet>
    <changeSet author="Jamie Bisotti (generated)" id="1254324457259-3">
        <addForeignKeyConstraint baseColumnNames="JOB_NAME, JOB_GROUP" baseTableName="QRTZ_JOB_LISTENERS" constraintName="FK_QRTZ_JOB_LST_1" deferrable="false" initiallyDeferred="false" referencedColumnNames="JOB_NAME, JOB_GROUP" referencedTableName="QRTZ_JOB_DETAILS"/>
    </changeSet>
    ...


The diff generated changelog seems to drop an existing addForeignKeyConstraint and then recreate the exact same addForeignKeyConstraint.

I'm using Firebird 2.1/Jaybird 2.1.1 and Liquibase 1.9.4 & this is a database for Quartz (it's the same version of Quartz in both cases do the schema shouldn't be different).

Any ideas?

Thanks,
   Jamie

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user