Sorry. I was meaning the data type of the column is bytea. On Wed, Jul 25, 2012 at 3:02 PM, Rebecca Clarke <r.clark...@gmail.com>wrote:
> The data was originally in a MDB as an OLE Object. I used GDAL to import > the data. (If this is of any use). > > > On Wed, Jul 25, 2012 at 2:59 PM, Rebecca Clarke <r.clark...@gmail.com>wrote: > >> There is no index on the table. >> >> postgis_full_version >> >> ------------------------------------------------------------------------------------------------------- >> POSTGIS="1.5.5" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September >> 2009" LIBXML="2.7.8" USE_STATS >> >> version >> >> ------------------------------------------------------------------------------------------------------- >> PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real >> (Debian 4.4.5-8) 4.4.5, 64-bit >> >> >> Until this Monday, I was using Postgresql 8.4 and postgis 1.5.1 >> >> >> On Wed, Jul 25, 2012 at 2:54 PM, Sandro Santilli <s...@keybit.net> wrote: >> >>> On Wed, Jul 25, 2012 at 02:27:14PM +0100, Rebecca Clarke wrote: >>> > Your code below works for me also. It's obviously just my data. >>> > >>> > the field is data type bytea: >>> > >>> > \x010300000000000000 >>> >>> Looks like HEXWKB to me, for "POLYGON EMPTY". >>> What makes you think it is "bytea" ? >>> >>> > I ran: >>> > >>> > select st_astext(the_geom) from tbl where id = 6052 >>> > >>> > and it returns: "POLYGON EMPTY" >>> > >>> > When I run the st_isvalid on it: >>> > >>> > select st_isvalid(the_geom) from tbl where id = 6052 >>> > or >>> > select st_isvalid(the_geom::geometry) from tbl where id = 6052 >>> > >>> > It throws the segmentation error. >>> > >>> > I just upgrade to postgis 1.5.5 and this made no difference. >>> >>> Can you show the output of "SELECT postgis_full_version()" >>> _and_ the output of "SELECT version()" ? >>> Is there an index on "tbl" ? >>> >>> --strk; >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@postgis.refractions.net >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >> >> >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users