Yes I do, but my problem occurs when running the SQL to install the various functions into that schema. I had to comment out geocode/reverse_geocode.<div id=":qg">sql (which is included as part of create_geocode.sql) in order for the rest to install successfully.<br>
<br>There appears to be a syntax error with the reverse_geocode function:<br><br>psql:geocode/reverse_geocode.<div id=":qg">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><br>I'm not too familiar with writing them, so I'm not able to stop/debug the error. Any ideas?<br><br>Thanks,<br><br>Johnathan<br></div></div><br><br><div class="gmail_quote">
On Thu, Apr 28, 2011 at 4:09 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">All the functions should have been installed in tiger
schema.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Do you have a tiger schema?</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div><span></span><span></span><font face="Arial"><font color="#0000ff"><font size="2"><span>Leo</span></font></font></font></div>
<div><font face="Arial"><font color="#0000ff"><font size="2"><span></span></font><a href="http://www.postgis.us" target="_blank"><font size="2">h<span>ttp://www.postgis.us</span></font></a></font></font><br></div>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Johnathan Leppert<br><b>Sent:</b> Thursday, April 28, 2011 10:39
AM<br><b>To:</b> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><b>Subject:</b>
[postgis-users] Geocoder (from extras)<br></font><br></div><div><div></div><div class="h5">
<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></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><i><font color="#CCCCCC">Johnathan</font></i><div><font color="#CCCCCC">Software Architect & Developer</font></div><div><font color="#CCCCCC">Columbus, Ohio</font></div>
<div><i><font color="#CCCCCC"><a href="http://twitter.com/#%21/iamleppert" target="_blank">Follow me on Twitter: @iamleppert</a></font></i></div><br>