1
I have a Postgresql database that is used for an application developed in Delphi, but now I will have to use this same bank for a new application that will be developed in Java, need some columns that do not yet exist in some tables already used, my doubt is if I add a column to an existing table and that is already used this could harm the program that is already running on top of that table?
3
You only have to worry about the conditions of the same, for example, if you put these new columns and put them as "NOT NULL" in an "INSERT" of the application Delphi ai will give problem.
But then just give default values, another example. If the column cannot be empty, put that when you do not receive the data, the value will take 0.
In case that column will not be NOT NULL as it will be a non obligatory additional field
Then send Uncle Vader
rs thanks for the help
0
Hello, R. Santos!
It’s a fairly relative question.
It depends on how the source code of the software was made, for example: If I have any SELECT * FROM... your new column will appear in the results, this can complicate if that column has a different destination like defining whether something is active or not, etc. Otherwise, I see no problems...
Browser other questions tagged postgresql table
You are not signed in. Login or sign up in order to post.
Migration is used to mitigate these possible problems. See the answers to https://answall.com/q/207501/64969, this may help clarify
– Jefferson Quesado