[postgis-users] Geocoder (from extras)

[Johnathan Leppert]

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.
sql (which is included as part of create_geocode.sql) in order for the rest
to install successfully.

There appears to be a syntax error with the reverse_geocode 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"

I'm not too familiar with writing them, so I'm not able to stop/debug the
error. Any ideas?

Thanks,

Johnathan


On Thu, Apr 28, 2011 at 4:09 PM, Paragon Corporation <lr at pcorp.us> wrote:

>  All the functions should have been installed in tiger schema.
> Do you have a  tiger schema?
>
> Leo
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
*Johnathan*
Software Architect & Developer
Columbus, Ohio
*Follow me on Twitter: @iamleppert <http://twitter.com/#%21/iamleppert>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110428/fe5eef4a/attachment.html>