[postgis-users] importing shape files nightmare!

[Gérald Fenoy]

HI Christo,
argh realy sorry there is one dot before underscore in the link.
The link is then http://www.postgis.fr/gentoo/dev-db/postgis/ 
postgis-1.0.4_p20050914.ebuild (you could also use the http://www. 
01map.net/gentoo/dev-db/postgis).
A new will be posted in my blog today (http://www.postgis.fr/?q=blog/1).

Le 15 sept. 05 à 14:23, christomec a écrit :

> Hi GXrald,
>
> Trying to download
>> http://www.postgis.fr/gentoo/dev-db/postgis/ 
>> postgis-1.0.4._p20050914.ebuild
> I get : "Page non trouvée"
>
> Trying to browse www.postgis.fr/gentoo/dev-db/postgis/ I get: "You  
> don't
> have permission to access /gentoo/dev-db/postgis/ on this server."
>
> Thank you,
> Christo
>
>
>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> _______________________________________________
>>> 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:43296627203588060018796!
>>
>>
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>