Problem updating database model

Classic Servoy
1

Good evening from Gran Canaria.

I have updated a table to change the length of a field from 25 to 60 (char varying), but when I import the solution showing the database model changes I get a warning with that field telling that it has changes to 60 and the dtabase is not updated.

I have checked the Allow Database Model Changes.

What am I doing wrong?

Thanks in advance.

2

Servoy won’t change the column at import time.
When you check “allow datamodel changes” servoy will create not existing tables and/or columns but will never change a column if it’s already there.
You need to take care of that manually.

3

Hi Nicola

Thanks for your reply.

After your suggestion what I´ve done is use pgAdmin to change the column length, now the DB has a length of 60 but I´m not allowed to enter more than 25 chars. I re-imported the solution and the same warning. Do I have to do anything else?

Thanks.

4

Hi Juan,

When changing the database schema outside of Servoy you are required to restart Servoy Server to make it see the changes.
When in developer you can restart too or reload the tables via the database node.

Hope this helps.

5

Changing the datamode can also be done inside the pre/post import hooks using the maintenance plugin, which also has a function to reload the datamodel from the database into the Application Server’s memory, without having to restart.

Paul

6

Thank you all guys.

I like that one with the maintenance plugin. Will give it a try.