[postgis-users] importing shape files nightmare!

[Gérald Fenoy]

Hi,
sorry for redundency but ... you could find the  
postgis-1.0.4_p20050914.ebuild here : http://www.postgis.fr/gentoo/ 
dev-db/postgis/postgis-1.0.4._p20050914.ebuild .

Feel free to send any comments here.

Cordially.

Le 15 sept. 05 à 09:12, christomec a écrit :

> Thank you,
>
> I currently have postgis-1.0.1_p20050727-r1 emerged on my gentoo  
> box, why
> does the select postgis_full_version() return POSTGIS="1.1.0CVS"?
>
> And where can I find a postgis-1.0.4 ebuild?
>
>
>> 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!
>>
>>
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>