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