[postgis-users] 1.5.2 Issue

[Ricardo Bayley]

Hi fellows,

I had a ver nice reverse geocode function on my postgis 1.5.1 box.

When I install it to my new 1.5.2 postgis installation I get this....

ERROR:  no existe el tipo «geometry»

Which in english means type does not exist ?? huh ?? How, why ??

This is a piece of my function code

*CREATE OR REPLACE FUNCTION fn.reversegeo (IN x numeric, IN y numeric, IN
epsg integer DEFAULT 4326)*
*  RETURNS TABLE(.....)*

* **DECLARE*
* **x ALIAS FOR $1; y ALIAS FOR $2;** **epsg ALIAS FOR $3;*
* **new_geo geometry;*


Why when creating the function postgres tells me geometry type does not
exist ? I tried both small and Capital cases.


BTW config is:  postgresql 9.0 with postgis 1.5.2 from the stack builder on
my winxp box.

PostGIS_Full_Version() :

"POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.6.1, 21 August 2008"
LIBXML="2.7.6" USE_STATS"


Thanks in advanced,

Ricardo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101008/2d6ec319/attachment.html>