Skip to content

Ninniku IT Hub

Provide open-source solutions for businesses.

Menu
  • Home
  • Technical Support
  • Traning
    • Arduino for IoT and ERP Integration
  • Expert Certification
  • Plug-ins (Taiwan)
    • Accounting for Taiwan
    • Meeting Room Booking
Menu

PostgreSQL 9.6 export loss operator

Posted on 2023-02-22

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.-)
);

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Apple
  • iDempiere
  • IoT
  • IT Tools
  • Linux
  • Productivity
  • SAP
  • uncategorized
  • Wordpress

Tags

Access Arduino Bad Dept Booking Business One Button Confirmation Developer ERP Exam Free git github GPIO iDempiere Jasper Report Java Language LED Linux M1 MacOS Material Receipt Maven Meeting room Open Source OSGi Period Control Permission Plug-In PostgreSQL Potentiometer Premiere Pro Process PWM Raspberry PI Resistor Role Sales Management SWT Tips Ubuntu Video Editor Wordpress Workflow

Recent Posts

  • Unlocking Creative Potential: Top Open-Source Alternatives to Adobe Premiere Pro for Video Editing
  • Enhancing Meeting Room Efficiency with the iDempiere Meeting Room Booking Plug-in
  • How to Create a GitHub Repository from a Local Folder
  • Demystifying OSGi Service Ranking: A Comprehensive Guide
  • PostgreSQL Time Travel: Upgrading from Version 9.6 to 14

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
©2023 Ninniku IT Hub | Design: Newspaperly WordPress Theme