PostgreSQL 9.6 export loss operator
iDempiere

PostgreSQL 9.6 export loss operator

2023-02-22 最後更新:2023-03-04) · 1 分鐘 · Ray Lee (System Analyst)

Every time I restore the database to the development environment, these two operators will be missing. it needs to be added.

CREATE OPERATOR adempiere.+ (
    PROCEDURE = adempiere.adddays,
    LEFTARG = timestamp with time zone,
    RIGHTARG = numeric,
    COMMUTATOR = OPERATOR(adempiere.+)
);
CREATE OPERATOR adempiere.- (
    PROCEDURE = adempiere.subtractdays,
    LEFTARG = timestamp with time zone,
    RIGHTARG = numeric,
    COMMUTATOR = OPERATOR(adempiere.-)
);

English Version

Every time I restore the database to the development environment, these two operators will be missing. They need to be added.

CREATE OPERATOR adempiere.+ (
    PROCEDURE = adempiere.adddays,
    LEFTARG = timestamp with time zone,
    RIGHTARG = numeric,
    COMMUTATOR = OPERATOR(adempiere.+)
);
CREATE OPERATOR adempiere.- (
    PROCEDURE = adempiere.subtractdays,
    LEFTARG = timestamp with time zone,
    RIGHTARG = numeric,
    COMMUTATOR = OPERATOR(adempiere.-)
);

日本語版

データベースを開発環境にリストアするたびに、以下の2つのオペレーターが欠落します。手動で追加する必要があります。

CREATE OPERATOR adempiere.+ (
    PROCEDURE = adempiere.adddays,
    LEFTARG = timestamp with time zone,
    RIGHTARG = numeric,
    COMMUTATOR = OPERATOR(adempiere.+)
);
CREATE OPERATOR adempiere.- (
    PROCEDURE = adempiere.subtractdays,
    LEFTARG = timestamp with time zone,
    RIGHTARG = numeric,
    COMMUTATOR = OPERATOR(adempiere.-)
);

Ray Lee (System Analyst)
作者 Ray Lee (System Analyst)

iDempeire ERP Contributor, 經濟部中小企業處財務管理顧問 李寶瑞