← Back to team overview

dhis2-devs team mailing list archive

Upgrade from 2.28 to 2.29 to 2.30: ALTER TABLE public.relationshipitem OWNER to dhis;

 

Dear All,

 

I did upgrade from 2.28 to 2.29 checked everything was working well

then upgraded from 2.29 to 2.30 checked everything was working well too.

 

few weeks later i did the same as above but upgrading from 2.29 to 2.30 had
this error: ERROR: permission denied for relation relationshipitem

so i ran this psql query and everything was ok: ALTER TABLE
public.relationshipitem OWNER to dhis;

 

Is this a problem in the upgrade script? is the ownership of the table
possibly not handled in the upgrade script?

The problem is solved for now for me, but I am sharing if this could
improved somehow.

 

All the best,

Bernard

 




Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib.ima@xxxxxxxxxx> lib.ima@xxxxxxxxxx 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org

 

 

PNG image