[postgis-users] importing shape files nightmare!

[christomec]

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!
>
>
>