<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17573"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=026300720-28042011><FONT color=#0000ff
size=2 face=Arial>All the functions should have been installed in tiger
schema.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=026300720-28042011><FONT color=#0000ff
size=2 face=Arial>Do you have a tiger schema?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=026300720-28042011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=026300720-28042011></SPAN><SPAN
class=026300720-28042011></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=026300720-28042011>Leo</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=026300720-28042011></SPAN></FONT><A href="http://www.postgis.us"><FONT
size=2>h<SPAN
class=026300720-28042011>ttp://www.postgis.us</A></SPAN></FONT></FONT></FONT><BR></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Johnathan Leppert<BR><B>Sent:</B> Thursday, April 28, 2011 10:39
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Geocoder (from extras)<BR></FONT><BR></DIV>
<DIV></DIV>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:<BR><BR>postgres@li63-206:/tmp/tiger_2010$ /usr/local/pgsql/bin/psql -d geo
-f ./create_geocode.sql<BR>psql:./create_geocode.sql:4: ERROR: schema
"tiger" does not exist<BR>BEGIN<BR>psql:./create_geocode.sql:7: NOTICE:
type "norm_addy" does not exist, skipping<BR>DROP TYPE<BR>CREATE TYPE<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>psql:geocode/reverse_geocode.sql:101: ERROR: return type
mismatch in function declared to return record<BR>DETAIL: Function's final
statement must be SELECT or INSERT/UPDATE/DELETE RETURNING.<BR>CONTEXT:
SQL function "reverse_geocode"<BR>ROLLBACK<BR><BR>Anyone have any ideas? Using
postgis-2.0.0SVN<BR><BR>Thanks,<BR><BR>Johnathan<BR></BODY></HTML>