hi frank, you are right. meanwhile i noticed by myself that indeed it was a problem with my client pgAdminIII. the rows just seemed to long. it seems that the pgAdmindriver has a 64k limit when retrieving rows from postgre.
the querys worked fine when using phppgadmin or psql. thank you anyway. regards. stefan > -----Ursprüngliche Nachricht----- > Von: PostGIS Users Discussion <[email protected]> > Gesendet: 02.08.07 12:31:21 > An: PostGIS Users Discussion <[email protected]> > Betreff: Re: [postgis-users] problem with shp2pgsql / psql import > > On Tue, Jul 31, 2007 at 11:58:32AM +0200, Stefan Zweig wrote: > > i have attached an excerpt of the _g2793.sql which creates the > > table and imports one geometry row. maybe anybody can try importing > > this in his/her postgis and see whether postgis gives as well a > > null geometry after > > > > select id, name, astext(the_geom) from _g2793 > > Are you sure the geometry is null? What does the following query > return? > > SELECT id, name, the_geom IS NULL, length(astext(the_geom)), > summary(the_geom) FROM _g2793; > > I get this: > > id | name | ?column? | length | summary > > -----------------+----------+----------+--------+---------------------------------- > 632760049010583 | Saarland | f | 100818 | > : MultiPolygon[BS] with 1 > elements > : Polygon[] with 1 rings > : ring 0 has 5294 points > : > (1 row) > > What client are you using? I see the astext() output in psql but > not in pgAdmin, perhaps because the value is too long. > > > i have no idea what is wrong with the INSERT statement. is there > > something like a geometry/WKT-validator? > > Nothing is wrong with the statement as far as I can tell. Try psql > if you aren't using it already. > > -- > Michael Fuhr > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > __________________________________________________________________________ Erweitern Sie FreeMail zu einem noch leistungsstärkeren E-Mail-Postfach! Mehr Infos unter http://produkte.web.de/club/?mc=021131 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
