In PostgreSQL all column are not updating

[salman.b]

Hello
I created an application using HSQLDB. after some days, I added some new attributes in some of the entities and saved it now when I change the database to PostgreSQL and when I try to open the entity screen in which I have added attributes, facing this error
PSQLException: ERROR: column “latitude” of relation “ems_address” does not exist
** Position: 131**

for example, I have an entity address and added attribute latitude when I was working with HSQL
now when I open address entity with PostgreSQL DB facing the error

can anyone suggest me how to solve the error

[gorelov (Gleb Gorelov)]

Hi,

You need to generate update scripts for PostgreSQL either. Bear in mind that Studio generates update scripts only for active DB, so if your project is intended to work with several databases you need to generate update scripts for each DB.

Regards,
Gleb

[salman.b]

Thank you so much it worked…