[postgis-users] importing shape files nightmare!

christomec christo at mecola.com
Thu Sep 15 02:52:08 PDT 2005


So is POSTGIS="1.1.0CVS" is in actual fact 1.0.3?

If so, then why is everything working on my suse box which is clearly
stating POSTGIS="1.0.3" when I do a postgis_full_version()?


> Version 1.0.4 of PostGIS contains a fix for your case.
> --strk;
>
> On Wed, Sep 14, 2005 at 11:38:54PM +0200, christomec wrote:
>> I have two machines, suse and gentoo
>>
>> suse:
>>
>> select version();
>> PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5
>> 20050117 (prerelease) (SUSE Linux)
>>
>> select postgis_full_version();
>> POSTGIS="1.0.3" PROJ="Rel. 4.4.8, 3 May 2004" USE_STATS DBPROC="0.3.0"
>> RELPROC="0.3.0"
>>
>> gentoo:
>>
>> select version();
>> PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC
>> i686-pc-linux-gnu-gcc (GCC) 3.3.6 (Gentoo 3.3.6, ssp-3.3.6-1.0,
>> pie-8.7.8)
>>
>> select postgis_full_version();
>> POSTGIS="1.1.0CVS" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
>> DBPROC="0.3.1" RELPROC="0.3.1"
>>
>> running:
>>
>> shp2pgsql -c streets.shp streets | psql -d dbname
>>
>> suse, no problem!
>>
>> gentoo: ERROR:  unterminated quoted string at or near
>> "'010500000001000000010...
>>
>> trying:
>>
>> shp2pgsql -D streets.shp streets dbname > streets.sql
>>
>> suse, no problem!
>>
>> gentoo:
>> Shapefile type: Arc
>> Postgis type: MULTILINESTRING[2]
>> Segmentation fault
>>
>> finally:
>>
>> Trying to import streets.sql generated on the suse machine into
>> postgresql
>> running on the gentoo machine also fails:
>>
>> psql:streets.sql:1350: invalid command \N
>>
>> What is it with the gentoo installation? What should I upgrade or
>> downgrade to remedy this problems I'm having?
>>
>> Please help, it is really important that I get this done and I'm really
>> stuck trying to solve it.
>>
>> Kind Regards,
>> Christo Du Preez
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> !DSPAM:4329119c36131738919822!
>
>
>




More information about the postgis-users mailing list