Interesting, I run the same query & get your same results... so that shows the object is there. So why would astext(the_geom) return nothing? Maybe it doesn't return something when the size is too large?
Thanks! Kevin Neufeld wrote: > > I don't have any problems loading your sql file into my database > (running PG8.3.3, PGIS 1.3.3) > > postgis=# \i testtable.sql > psql:testtable.sql:3: NOTICE: CREATE TABLE will create implicit > sequence "testtable_gid_seq" for serial column "testtable.gid" > psql:testtable.sql:3: NOTICE: CREATE TABLE / PRIMARY KEY will create > implicit index "testtable_pkey" for table "testtable" > CREATE TABLE > addgeometrycolumn > -------------------------------------------------------------- > kneufeld.testtable.the_geom SRID:-1 TYPE:MULTIPOLYGON DIMS:2 > > (1 row) > > > postgis=# select ST_GeometryType(the_geom), ST_IsValid(the_geom), > ST_NPoints(the_geom) from testtable; > st_geometrytype | st_isvalid | st_npoints > -----------------+------------+------------ > ST_MultiPolygon | t | 8655 > (1 row) > > > -- Kevin > > sub3 wrote: >> Hi, >> >> I am having a problem. I convert a shp file using shp2pgsql. One of the >> multipolgons is very large (line is about 277k characters long). After I >> import into postgresql, this geometry is empty. >> No error from postgis. >> No error from postgresql. >> >> I am only making a guess that it is the line size, I am not sure. Is >> there >> a setting which would fix this? >> >> Thanks for any help. >> >> --- >> Attached is the .sql script. >> http://www.nabble.com/file/p18285042/testtable.sql testtable.sql > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://www.nabble.com/import-large-multipolygon-tp18285042p18285274.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
