Add column in a table already used by a program, could it harm the functioning of it?

Asked

Viewed 152 times

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?

postgresql table

  • Migration is used to mitigate these possible problems. See the answers to https://answall.com/q/207501/64969, this may help clarify

2 answers

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.