search

maschinenmensch / edifice

A database of the built environment in Chicago
5 stars 1 forks source link

Why was 'SET search_path = tif, pg_catalog" commented out before property_values table is created (in edifice_initialization_script.sql)? #18

Closed mccc closed 11 years ago

mccc commented 11 years ago

This is in or around line 1157 of edifice_initialization_script.sql

It seems to induce the following errors when running that script:

psql:sql_init_scripts/edifice_initialization_script.sql:1210: ERROR:  relation "tif.property_values" does not exist
LINE 2: ...((SELECT count(property_values.pin) AS count FROM tif.proper...
                                                             ^

psql:sql_init_scripts/edifice_initialization_script.sql:1960: ERROR:  relation "tif.property_values" does not exist
LINE 2: ...ent_pin, county_temp_distinct.property_class FROM tif.proper...
                                                             ^
psql:sql_init_scripts/edifice_initialization_script.sql:11605: ERROR:  relation "property_values" 
does not exist
psql:sql_init_scripts/edifice_initialization_script.sql:11612: ERROR:  relation "property_values" 
does not exist

I couldn't see any reason not to uncomment it.