Liquibase Community Forum
2010-12-13 13:30:50 UTC
A new topic, '[ISSUE] When removing PK column', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=832.new#new
The text of the topic is shown below:
Hi all,
I've got a table with a column A that is PK.
I want to remove that column and create a new one, named B, that would become the PK.
I used the diffChangeLog command to automatically generate the ChangeLog and apply it on the fly (I'm creating a workflow involving reworking a DB from Hibernate code).
The changeLog propose:
insert new column B
add PK on B (that fails)
drop PK on table X
Which crashs on MySQL as we can't deal with two PK at the same time...
Regards,
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.
You can see it at
http://liquibase.org/forum/index.php?topic=832.new#new
The text of the topic is shown below:
Hi all,
I've got a table with a column A that is PK.
I want to remove that column and create a new one, named B, that would become the PK.
I used the diffChangeLog command to automatically generate the ChangeLog and apply it on the fly (I'm creating a workflow involving reworking a DB from Hibernate code).
The changeLog propose:
insert new column B
add PK on B (that fails)
drop PK on table X
Which crashs on MySQL as we can't deal with two PK at the same time...
Regards,
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.