I’ve attempted to update to the most recent version of the Xtuple database. I am currently using database version 4.10.1
I tried updating via Updater versions 2.4.0 and 2.5.0 and received the same error via the following sequence:
Load updater and login
Load update package (both 4.11.0 & and 4.11.1)
Pre-check is passed, all pre-requisites passed
Select “Start Update”
Receive the following error in red:
The following error was encountered while trying to import postbooks-upgrade.sql into the database:
ERROR: permission denied: “RI_ConstraintTrigger_a_115688” is a system trigger
(42501)
QPSQL: Unable to create query
The upgrade has been aborted due to an error and your database was rolled back to the state it was in when the upgrade was initiated.
The upgrade has been aborted due to an error and your database was rolled back to the state it was in when the upgrade was initiated.
Any help is appreciated. This is the 1st upgrade we’ve done with the PLV8 code: plv8.start_proc = ‘xt.js_init’ which I belive is installed correctly.
Any help appreciated!