dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

 Just TRUNCATE the table or "DELETE FROM foo WHERE 0" should work as
well. If columns need to be added, just do it. No need to drop the
table just because of this.

The question for me is, what about other views that are really not
part of the main DHIS2 distribution? Even if we managed to include the
"stock views" there may be people who want to build analysis outside
of the DHIS2 box. Dropping tables really does complicate matters.
Otherwise, we would need to determine, what if any impact dropping a
table will have, and then figure out how to resolve it.

I did not realize this actually happened, but it is definitely an
issue for us as well here in Zambia.