[postgis-users] importing shape files nightmare!

[strk at refractions.net]

On Thu, Sep 15, 2005 at 11:52:08AM +0200, christomec wrote:
> So is POSTGIS="1.1.0CVS" is in actual fact 1.0.3?

Might be, the 1.1 and 1.0 are two different branches in CVS,
and 1.1.0CVS is there since about 1.0.0 is out... there's no
easy way to tell which version of the code 1.1.0CVS is.

Since this is a bug with pgsql2shp what you should look at
is RCSID from it. It is shown running pgsql2shp w/out arguments.

--strk;

> 
> If so, then why is everything working on my suse box which is clearly
> stating POSTGIS="1.0.3" when I do a postgis_full_version()?
> 
> 
> > 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