[postgis-users] help with pgsql2shp error

[Sam Snellings]

select count(asEWKB(the_geom)) from global_points;

Returns the following error:

ERROR: function asewkb(geography) does not exist


Perhaps I don't understand your use of the term 'invalid geometry,' but I'm
using a geography datatype in both tables (airports and global_points) - so
there shouldn't be any geometry datatypes used.  Also, asEWKB(),
ST_isValid() and ST_isValidReason() don't work with geography data types,
correct?


-Sam


On Fri, Nov 5, 2010 at 6:19 PM, strk <strk at keybit.net> wrote:

> On Fri, Nov 05, 2010 at 04:43:54PM -0400, Sam Snellings wrote:
> > The output of postgis_full_version() is:
> >
> > POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September
> 2009"
> > LIBXML="2.6.26" USE_STATS
>
> Uhm. Maybe we need more fixes then.
>
> See if this query gives you the ERROR:
>  select count(asEWKB(the_geom)) from global_points;
>
> Anyway, would you want the invalid geometries in your shapefile ?
> I'd think you'd better fix the invalidities and then try again.
>
> See ST_isValid and ST_isValidReason.
>
> --strk;
>
>  ()   Free GIS & Flash consultant/developer
>  /\   http://strk.keybit.net/services.html
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101105/ba706684/attachment.html>