dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #51729
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