[postgis-users] Geocoder (from extras)

[Johnathan Leppert]

I fixed several bugs in the generated bash script to import US Census
shapefiles. Now I'm having an issue with the reverse geocoder SQL:

postgres at li63-206:/tmp/tiger_2010$ /usr/local/pgsql/bin/psql -d geo -f
./create_geocode.sql
psql:./create_geocode.sql:4: ERROR:  schema "tiger" does not exist
BEGIN
psql:./create_geocode.sql:7: NOTICE:  type "norm_addy" does not exist,
skipping
DROP TYPE
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:geocode/reverse_geocode.sql:101: ERROR:  return type mismatch in
function declared to return record
DETAIL:  Function's final statement must be SELECT or INSERT/UPDATE/DELETE
RETURNING.
CONTEXT:  SQL function "reverse_geocode"
ROLLBACK

Anyone have any ideas? Using postgis-2.0.0SVN

Thanks,

Johnathan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110428/f9e78b87/attachment.html>