Search code examples
sqlpostgresqlopenbravo

ERROR: Document processed/posted in sql

    SQL error:

   ERROR:  Document processed/posted

In statement:

   DELETE FROM "public"."m_inventory" WHERE "m_id"='1001270'

Does anyone know why and for what reason i am getting this error,Not able to delete that row

Solution

  • There is a trigger on the table.

    http://openbravo.hg.sourceforge.net/hgweb/openbravo/main/file/e5c51e8fd720/src-db/database/model/triggers/M_INVENTORY_TRG.xml

    IF DELETING THEN
  IF (:old.PROCESSED = 'Y') THEN
    RAISE_APPLICATION_ERROR(-20501, 'Document processed/posted') ;
  END IF;
END IF;