# Visual Paradigm does not update changes in attribute data type when connecting to database

**URL:** <https://forums.visual-paradigm.com/t/visual-paradigm-does-not-update-changes-in-attribute-data-type-when-connecting-to-database/16098>\
**Category:** Bug Reports\
**Tags:** database\
**Created:** [May 26, 2020, 8:22am UTC](https://forums.visual-paradigm.com/t/visual-paradigm-does-not-update-changes-in-attribute-data-type-when-connecting-to-database/16098 "2020-05-26T08:22:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![quetsja](https://avatars.discourse-cdn.com/v2/letter/q/dc4da7/32.png) [@quetsja](https://forums.visual-paradigm.com/u/quetsja)\
**Post date:** [May 26, 2020, 8:22am UTC](https://forums.visual-paradigm.com/t/visual-paradigm-does-not-update-changes-in-attribute-data-type-when-connecting-to-database/16098/1 "2020-05-26T08:22:39Z")

</div>

Hello,

We often use a direct connection between Visual Paradigm and a Postgres database in the cloud,

Which usually works great with updating the database from changes in Visual Paradigm.

Yesterday we discovered something unexpected: Visual Paradigm doesn’t seem to be able to update attributes where data type was changed in Visual Paradigm. It seems weird that Visual Paradigm cannot detect such changes. Is this a bug?

I have a Visual Paradigm (Version 16.1, Build 20200108) standard license,

And am connected to a PostgreSQL database in the cloud (AWS).

Best

Jan

---

<div class="post-metadata">

**Author:** ![Kit.So](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/kit.so/32/3594_2.png) [@Kit.So](https://forums.visual-paradigm.com/u/Kit.So)\
**Post date:** [May 28, 2020, 1:30am UTC](https://forums.visual-paradigm.com/t/visual-paradigm-does-not-update-changes-in-attribute-data-type-when-connecting-to-database/16098/2 "2020-05-28T01:30:47Z")

</div>

Hi quetsja,

Can you describe what changes you made in Visual Paradigm? We tested change data type can update to Postgres.

 ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/9/97d770b1411e5f69b3ab5d0060441166fd022808.png)

---

<div class="post-metadata">

**Author:** ![quetsja](https://avatars.discourse-cdn.com/v2/letter/q/dc4da7/32.png) [@quetsja](https://forums.visual-paradigm.com/u/quetsja)\
**Post date:** [May 29, 2020, 12:57pm UTC](https://forums.visual-paradigm.com/t/visual-paradigm-does-not-update-changes-in-attribute-data-type-when-connecting-to-database/16098/3 "2020-05-29T12:57:17Z")

</div>

Hi Kit.So,

as said we changed the data type of several fields in Visual Paradigm,  
and when updating the database it didn’t change these data types.

Also the Generate DDL file was empty. Only when new columns or tables are added or deleted database updates were performed.

What do you exactly suggest to test and/or to show a print screen of?

Best

---

<div class="post-metadata">

**Author:** ![Kit.So](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/kit.so/32/3594_2.png) [@Kit.So](https://forums.visual-paradigm.com/u/Kit.So)\
**Post date:** [June 1, 2020, 5:24am UTC](https://forums.visual-paradigm.com/t/visual-paradigm-does-not-update-changes-in-attribute-data-type-when-connecting-to-database/16098/4 "2020-06-01T05:24:39Z")

</div>

Hi quetsja,

Can you provide an example? Change from/to which data type can reproduce the problem?