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:
-
Testing Notes:
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
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