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

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Working As Designed
    • Affects Version/s: 1.7.00, 1.7.01
    • Fix Version/s: None
    • Component/s: Data
    • Labels:
      None
    • Environment:
      PostgreSQL
    • Rank:
      0|i000in:
    • Developer Notes:
      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.
    • Testing Notes:
      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

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code