Re: [gdal-dev] Re: Problem converting certain postgis tables to spatialite

2011-09-07 Thread Even Rouault
Le mercredi 07 septembre 2011 17:05:50, Andreas Neumann a écrit : > HI Jukka, > > Thank you for your thoughts. Yes, perhaps I should use update instead > of append. > > I actually found out what the problem is: > > Tables or views that do not have an entry in public.geometry_columns > (the

Re: [gdal-dev] Re: Problem converting certain postgis tables to spatialite

2011-09-07 Thread Chaitanya kumar CH
Andreas, Segfaulting is a serious issue. Can you tell the version of GDAL you used? On Wed, Sep 7, 2011 at 8:35 PM, Andreas Neumann wrote: > HI Jukka, > > Thank you for your thoughts. Yes, perhaps I should use update instead of > append. > > I actually found out what the problem is: > > Tables

Re: [gdal-dev] Re: Problem converting certain postgis tables to spatialite

2011-09-07 Thread Andreas Neumann
HI Jukka, Thank you for your thoughts. Yes, perhaps I should use update instead of append. I actually found out what the problem is: Tables or views that do not have an entry in public.geometry_columns (the postgis metadata table) cause the segmentation fault. Once the entry is there, it co

[gdal-dev] Re: Problem converting certain postgis tables to spatialite

2011-09-07 Thread Jukka Rahkonen
Andreas Neumann carto.net> writes: > > Hi, > > I am converting several tables from Postgis to SpatiaLite using > ogr2ogr. > > Here is my command: > > --- > ogr2ogr -append -lco LAUNDER=yes -lco SPATIAL_INDEX=yes -nln > av_grenzpunkte -f SQLite uster.sqlite PG:"dbname='mydb' h