Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-104

Schema name in db_lookup tables for PostgreSQL incorrectly defined as public

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Working As Designed
    • 1.7.00, 1.7.01
    • None
    • Data
    • None
    • PostgreSQL
    • Hide
      The PostgreSQL insert_data scripts for the db_lookup tables were updated to reflect the correct schema name in the c_db_fullschema column.
      Show
      The PostgreSQL insert_data scripts for the db_lookup tables were updated to reflect the correct schema name in the c_db_fullschema column.
    • Hide
      The running of the data scripts is tested as part of the bamboo install tests.

      Bamboo Postgres build #278

      Build failed. Reverting changes. Will be fixed in 1.7.03
      Show
      The running of the data scripts is tested as part of the bamboo install tests. Bamboo Postgres build #278 Build failed. Reverting changes. Will be fixed in 1.7.03

    Description

      The PostgreSQL insert_data scripts for the db_lookup tables have the wrong schema name defined in the c_db_fullschema column. Currently these scripts have "public" defined as the schema. The following scripts need to be updated to reflect the correct schema for each of the db_lookup tables.


      crc_db_lookup_postgresql_insert_data.sql / c_db_fullschema = i2b2demodata

      im_db_lookup_postgresql_insert_data.sql / c_db_fullschema = i2b2imdata

      ont_db_lookup_postgresql_insert_data.sql / c_db_fullschema = i2b2metadata

      work_db_lookup_postgresql_insert_data.sql / c_db_fullschema = i2b2workdata


      Attachments

        Activity

          jmd86 Janice Donahoe added a comment - - edited
          Issues found in Bamboo testing. Will be addressed in future release
          jmd86 Janice Donahoe added a comment - - edited Issues found in Bamboo testing. Will be addressed in future release

          People

            mem61 Mike Mendis
            jmd86 Janice Donahoe
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: