Re: [postgis-users] I'm so close!
Please ignore this note. I solved the issue. It was very simple, of course. On Mon, Jul 9, 2012 at 11:30 AM, Eric Aspengren wrote: > And yet... > > I've gotten just about everything done in a PostGIS/Tiger Geocoder install > and I get to create_geocode.sh and get a few problems. > > I couldn't this problem being addressed on this list or anywhere else. Any > ideas? > > I get this after all the tables are generated: > > psql:census_loader.sql:102: NOTICE: function > loader_generate_census(text[],text) does not exist, skipping > DROP FUNCTION > CREATE FUNCTION > DELETE 0 > INSERT 0 1 > INSERT 0 1 > INSERT 0 1 > create_census_base_tables > --- > Tables already present > (1 row) > > SET > BEGIN > psql:create_geocode.sql:23: NOTICE: type "norm_addy" does not exist, > skipping > DROP TYPE > CREATE TYPE > CREATE FUNCTION > CREATE FUNCTION > CREATE FUNCTION > psql:utility/levenshtein_ignore_case.sql:5: ERROR: function > levenshtein(text, text) does not exist > LINE 3: SELECT levenshtein(upper($1), upper($2)); > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > psql:normalize/end_soundex.sql:17: ERROR: current transaction is aborted, > commands ignored until end of transaction block > psql:normalize/count_words.sql:32: ERROR: current transaction is aborted, > commands ignored until end of transaction block > psql:normalize/state_extract.sql:90: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:normalize/get_last_words.sql:29: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:normalize/location_extract_countysub_exact.sql:56: ERROR: current > transaction is aborted, commands ignored until end of transaction block > psql:normalize/location_extract_countysub_fuzzy.sql:89: ERROR: current > transaction is aborted, commands ignored until end of transaction block > psql:normalize/location_extract_place_exact.sql:62: ERROR: current > transaction is aborted, commands ignored until end of transaction block > psql:normalize/location_extract_place_fuzzy.sql:90: ERROR: current > transaction is aborted, commands ignored until end of transaction block > psql:normalize/location_extract.sql:85: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:normalize/normalize_address.sql:708: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:normalize/pprint_addy.sql:10: ERROR: current transaction is aborted, > commands ignored until end of transaction block > psql:normalize/pprint_addy.sql:43: ERROR: current transaction is aborted, > commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:14: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:22: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:32: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:48: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:58: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:201: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:213: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:240: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:252: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/rate_attributes.sql:29: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/rate_attributes.sql:80: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/includes_address.sql:94: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/interpolate_from_address.sql:94: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/geocode_address.sql:435: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/geocode_location.sql:99: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/geocode_intersection.sql:148: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/geocode.sql:37: ERROR: current trans
[postgis-users] I'm so close!
And yet... I've gotten just about everything done in a PostGIS/Tiger Geocoder install and I get to create_geocode.sh and get a few problems. I couldn't this problem being addressed on this list or anywhere else. Any ideas? I get this after all the tables are generated: psql:census_loader.sql:102: NOTICE: function loader_generate_census(text[],text) does not exist, skipping DROP FUNCTION CREATE FUNCTION DELETE 0 INSERT 0 1 INSERT 0 1 INSERT 0 1 create_census_base_tables --- Tables already present (1 row) SET BEGIN psql:create_geocode.sql:23: NOTICE: type "norm_addy" does not exist, skipping DROP TYPE CREATE TYPE CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:utility/levenshtein_ignore_case.sql:5: ERROR: function levenshtein(text, text) does not exist LINE 3: SELECT levenshtein(upper($1), upper($2)); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. psql:normalize/end_soundex.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/count_words.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/state_extract.sql:90: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/get_last_words.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_countysub_exact.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_countysub_fuzzy.sql:89: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_place_exact.sql:62: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_place_fuzzy.sql:90: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract.sql:85: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/normalize_address.sql:708: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/pprint_addy.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/pprint_addy.sql:43: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:22: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:48: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:201: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:213: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:240: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:252: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/rate_attributes.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/rate_attributes.sql:80: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/includes_address.sql:94: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/interpolate_from_address.sql:94: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_address.sql:435: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_location.sql:99: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_intersection.sql:148: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode.sql:131: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/reverse_geocode.sql:222: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geo