Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-1837

upgradeVersion should execute SQL to change column type for PostgreSQL

    XMLWordPrintable

Details

    Description

      The upgrade to version 3.3.0 requires changes in the type column for table cm_ssh_keys and the job_type column for table cm_so_jobs. Due to a bug in adodb5 the columns are not changed when the ./Console/cake upgradeVersion command is run and the database used is PostgreSQL. User instructions for the SQL to execute to remedy the issue are currently available at

      https://spaces.at.internet2.edu/display/COmanage/Upgrading+Registry+to+v3.3.0 

      Instead of documenting the work around, the _ug330() functions for the related models should instead detect that PostgreSQL is the database being used and then execute the SQL as part of the upgradeVersion command.

       

      Attachments

        Activity

          People

            benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
            scott.koranda.3@at.internet2.edu Scott Koranda SCG (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: