ERROR: commutator operator - is already the commutator of operator + - Mailing list pgsql-bugs

From shohorab hossain
Subject ERROR: commutator operator - is already the commutator of operator +
Date
Msg-id CALBMUWWkDcVwAyba5gAN_D0cbmP7wQwtJ3615tkhwJyQw=DJkA@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: commutator operator - is already the commutator of operator +
List pgsql-bugs

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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18708: regex problem: (?:[^\d\D]){0} asserts with "lp->nouts == 0 && rp->nins == 0"
Next
From: Tom Lane
Date:
Subject: Re: ERROR: commutator operator - is already the commutator of operator +