Whenever I try to restore a dump database backup to PostgreSQL version 17.1, I receive the following error log. The dump is from PostgreSQL version 15.8.
What is this error and how can I fix it?.
pg_restore: error: could not execute query: ERROR: commutator operator - is already the commutator of operator +
Command was: CREATE OPERATOR adempiere.- (
FUNCTION = adempiere.subtractdays,
LEFTARG = interval,
RIGHTARG = numeric,
COMMUTATOR = OPERATOR(adempiere.-)
);
pg_restore: error: could not execute query: ERROR: operator does not exist: interval adempiere.- numeric
Command was: ALTER OPERATOR adempiere.- (interval, numeric) OWNER TO adempiere;
With Best Regards
Shohorab Hossain