Change type of foreign key column

Hi,

I have a table that is referenced by many other tables by foreign keys.
When I change the type of its primary key column of this table, the type of all columns referencing this primary key get changed in all tables as well.

Great!!!

But after I have commited my changes to your teamwork server the columns referencing this primary key are back to its previous datatype. Furthermore the type of those columns can’t be changed manually.

Example:
before change of datatype
before_change

after change of dataype:
after_change

after commit:
after_commit

I am using Version 14.2 Build sp1_20180404

With regards,
Steffen

HI Steffen,

We are sorry for the inconvenience that it caused you. We can repeat this issue and is working on the fix, and we will notify you once the fix is available. Thank you.

Best Regards,

Antony.

1 Like

Hi Steffen,

I would like to let you know the FK data type not follow to change in PK after commit problem has been fixed. Please update the software to latest patch build (sp1_20180720ab or later) to get the problem fixed. Details about update to latest patch can be found at

  • Please make sure you have pressed the “Update to latest patch” button on the left hand side of the dialog right after launching the update program

Feel free to contact me if you require any further information.

Best regards,
Rain Wong

1 Like