My database dropped a column somehow when I was out of the office for a while, and I was able to figure out which it was and re-add it. The column was empty, so it didn't really lose any data. But, the new column I added does not have the primary and foreign key constraints needed.
I have another column in that table that has the constraints I need, but I haven't been able to figure out how to copy them to the new column, or create new constraints. I'm still learning the phpPgAdmin interface, and can't find anything in the help or the docs, so I am hoping that someone can point me in the right direction.
Thanks,
Jesse
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello all,
My database dropped a column somehow when I was out of the office for a while, and I was able to figure out which it was and re-add it. The column was empty, so it didn't really lose any data. But, the new column I added does not have the primary and foreign key constraints needed.
I have another column in that table that has the constraints I need, but I haven't been able to figure out how to copy them to the new column, or create new constraints. I'm still learning the phpPgAdmin interface, and can't find anything in the help or the docs, so I am hoping that someone can point me in the right direction.
Thanks,
Jesse