Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-98

PostgreSQL - create table script inventory.sql fails if some tables do not exist

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.11.2
    • 1.11.3, 1.12
    • None

    Description

      Current Situation

      • if inventory tables do not exist then the execution of the create table script inventory.sql ends with errors.
        Only 3 of 14 inventory tables will be created.
      • cause: invalid column type INT(1) defined for the RUN_TIME_IS_TEMPORARY column (tables INVENTORY_JOBS,INVENTORY_ORDERS)

      Desired behaviour

      • column type for RUN_TIME_IS_TEMPORARY must be changed to NUMERIC(1)

      Attachments

        Activity

          People

            sp Santiago Aucejo Petzoldt
            re Robert Ehrlich
            Robert Ehrlich Robert Ehrlich
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: