Error loading MIMIC-IV 3.0 with the V 2.2 postgres create.sql script

Prerequisites

• [X ] Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

Description of the issue, including:

• The admissions.csv in version 3.0 has values for too long for the 'language' column. This causes the load.sql script to fail:
• SET
  psql:load.sql:16: ERROR: value too long for type character varying(10)
  CONTEXT: COPY admissions, line 238, column language: "Kabuverdianu"
  and later with
  psql:load_admissions.sql:16: ERROR: value too long for type character varying(12)
  CONTEXT: COPY admissions, line 387, column language: "American Sign Language"

I fixed it by changing the 'language' column VARCHAR limit to 30. This will surely be fixed if and when a 3.0 version of code is released.

Start with the PostgreSQL schema in the v2.2 create.sql script and the loading steps in load.sql and load_admissions.sql. Reproduce the MIMIC-IV 3.0 admissions import using the reported language values, then verify that the schema accepts the data without COPY errors. Done means the documented load completes successfully with the affected language values.