[Liquibase-user] New Topic: generateChangeLog ant-tasks doesn't work correctly for primary keys (Postgresql)

[Liquibase Community Forum]

A new topic, 'generateChangeLog ant-tasks doesn't work correctly for primary keys (Postgresql)', has been made on a board you are watching.

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

The text of the topic is shown below:

Hi everyone,

I use a Postgres 8.2.17 database and tried to create my changelog by using the createChangeLog ant task. Then I try to update an empry database by using the script. It fails, because liquibase tries to create the primary key twice:
Code:

<changeSet author="user (generated)" id="1286549091209-128">
<addPrimaryKey columnNames="id, clientid" constraintName="blubb_pkey" tableName="blubb"/>
</changeSet>
Code:

<changeSet author="user (generated)" id="1286549091209-243">
<createIndex indexName="blubb_pkey" tableName="blubb" unique="true">
<column name="id"/>
<column name="clientid"/>
</createIndex>
</changeSet>

Kind regards
Oliver

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.