[postgis-users] Geocoder (from extras)

[Paragon Corporation]

All the functions should have been installed in tiger schema.
Do you have a  tiger schema?
 
Leo
 <http://www.postgis.us> http://www.postgis.us

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Johnathan Leppert
Sent: Thursday, April 28, 2011 10:39 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Geocoder (from extras)


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/98ba41db/attachment.html>