[postgis-users] importing shape files nightmare!

[christomec]

Thank you GXrald,

I got it, I accidentally used the wrong url the second time again.

My apologies

> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>
>> _______________________________________________
>> 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:43296a66227911752519151!
>
>
>