[postgis-users] error while loading dat for tiger geocoder

[David M. Kaplan]

Hi,

I am in the process of setting up the tiger geocoder for use with 
addresses from the state of virginia. I am using PostgreSQL 9.3.20, 
postgis 2.2.2 and postgis_tiger_geocoder 2.2.2.

The state loader script (for linux shell) generates an SQL error towards 
the end of the script relating to the following line (line 210 in my 
script):

${PSQL} -c "ALTER TABLE tiger_staging.VA_tabblock RENAME geoid10 TO 
tabblock_id;"

The error it generates is:

ERROR:  relation "tiger_staging.va_tabblock" does not exist

I am under the impression that this error is harmless as at this stage 
the tiger_staging schema is empty because the function 
loader_load_staged_data() has already been run, but I want to make sure.

If this is indeed a harmless error, then why is this line in the script?

Thanks,
David

-- 
**********************************
David M. Kaplan
Charge de Recherche 1

Institut de Recherche pour le Developpement (IRD)
UMR MARBEC (IRD/Ifremer/CNRS/UMII)
av. Jean Monnet
CS 30171
34203 Sete cedex
France

Phone: +33 (0)4 99 57 32 25
Fax: +33 (0)4 99 57 32 95

http://www.umr-marbec.fr/kaplan-david.html
**********************************