I have a PostgreSQL database that is used for an application developed in Delphi , but now I will have to use the same database for a new application that will be developed in Java , I need some columns that do not yet exist in some tables already used, my question is if I add a column to an already existing table and it is already used it could harm the program that is already running on top of that table? p>
Add column to a table already used by a program, could it damage the operation of it?
1
asked by anonymous 26.05.2017 / 13:12
2 answers
3
You just have to worry about the conditions of it, for example, if you put these new columns and put them as "NOT NULL" in an "INSERT" Delphi application there will be trouble.
But there you only give default values, another example. If the column can not be empty, put that when it does not receive the data, the value will assume 0.
26.05.2017 / 13:17
0
Hello, R. Santos!
It's a fairly relative issue.
It depends on how the source code of the software was done, for example: If I have some SELECT * FROM... your new column will appear in the results, this can complicate if this column has a different destination as to define if something is active or not, etc. . Otherwise, I see no problems ...
29.05.2017 / 00:14