From: | "christomec" <christo(at)mecola(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | postgis-users(at)postgis(dot)refractions(dot)net |
Subject: | importing shape files nightmare! |
Date: | 2005-09-14 21:34:00 |
Message-ID: | 61494.165.146.164.205.1126733640.squirrel@mail.bucknet.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-09-15 01:36:04 | Re: Partial dates |
Previous Message | Neil Conway | 2005-09-14 20:49:31 | Re: buffer manager |