[postgis-users] problem with shp2pgsql / psql import

[Stefan Zweig]

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 <postgis-users at postgis.refractions.net>
> Gesendet: 02.08.07 12:31:21
> An: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> 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
> postgis-users at postgis.refractions.net
> 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