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

cid:image002.png@01D36F50.572585A0

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: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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