Geocoder install fails trying to run create_census_base_tables()

[bpanulla]

I did a clean install of PostGIS 2.0 from RPM. When I started to set up the tiger2010 geocoder I saw an error in the output of create_geocode.sh

SELECT tiger.create_census_base_tables();: No such file or directory

On line 20:

${PSQL_CMD}  -d "${THEDB}" -f "SELECT tiger.create_census_base_tables();"

That should probably be -c to run inline SQL rather than -f.

[robe]

Thanks for the catch. Fixed at r9972 for 2.0 and r9973 for 2.1. I guess I missed it since I'm on windows and I guess I forgot to change the Linux script when I corrected the windows one.

FWIW: The PostGIS 2.1 (trunk), has tiger2011. It will work just fine with PostGIS 2.0. In fact I'm using it against my PostGIS 2.0 production install.

If you are starting out, you might want to go with that one as I hear they've made many improvements to the tiger 2011 dataset.