[postgis-users] I'm so close!

[Eric Aspengren]

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 <ericaspen at gmail.com> 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 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:geocode/census_tracts_functions.sql:57: ERROR:  current transaction
> is aborted, commands ignored until end of transaction block
> ROLLBACK
> CREATE FUNCTION
> ERROR:  function least_hn(character varying, character varying) does not
> exist
> LINE 1: ...idx_tiger_addr_least_address ON addr USING btree (least_hn(f...
>                                                              ^
> HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.
>
>
>
> --
> Eric Aspengren
> (402) 478-VOTE
> ericaspen at gmail.com
>



-- 
Eric Aspengren
(402) 478-VOTE
ericaspen at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120709/04c31f5e/attachment.html>