dhis2-devs team mailing list archive

[Quang Nguyen <quangnguyen111@xxxxxxxxx>]

On Wed, May 12, 2010 at 11:08 PM, Viet Nguyen <phamquocviet@xxxxxxxxx>wrote:

>
>
> On Wed, May 12, 2010 at 10:45 PM, Quang Nguyen <quangnguyen111@xxxxxxxxx>wrote:
>
>> org.postgresql.util.PSQLException: ERROR: column this_.mandatory does not exist
>>
>>
>
> You can fix this by adding  column "mandatory" to table "patientattribute"
> , and give a default value for all rows of that column.
>
> There should be more problems with your db.
>
> I can't not give a  sql patch because I don't know which version your db is
> ...
>
> Is it a production db or just a testing db ?
>
> If it just for testing, then you can just delete the tables and let the
> application auto create it at start up.
>
> If its production, then you can send me your db, I will try to update it
> without losing data...
>

I'm testing it with real data, Viet.
I can do your suggestion. However, what I'm thinking now is a few lines of
code to correct the database structure before system starts. I guess we
already have a place to put this code. Need to check it out.

Quang



>
>
> --
> Viet Nguyen
>
>