[postgis-users] Error while importing data

[strk at refractions.net]

On Sun, Mar 13, 2005 at 03:10:23PM +0000, Nigel Kukard wrote:
> Hi,
> 
> I see quite a number more errors (the_geom constraint violations) with
> 1.0.0rcX, if I paste one of these for you, could you tell me why its
> happening?

The message says you're trying to load a differently-dimensioned geometry
in a table you created with a dimension constraint.
The dimension constraint is added by AddGeometryColumn().

If shp2pgsql did the whole thing (call AddGeometryColumn() and feed
the geoms) we have a big bad bug, and having your case's shapefile
would help fixing it. 

--strk;

> 
> Regards
> Nigel
> 
> strk at refractions.net wrote:
> 
> >On Thu, Mar 10, 2005 at 06:00:20AM +0000, Nigel Kukard wrote:
> >
> >
> >>Hi Guys,
> >>
> >>I'm new to postgis. I got shape files from our local government,
> >>containing all data for South Afica.
> >>
> >>I installed postgresql 8.0.0, postgis 1.0.0-rc3, proj 4.4.9, gdal 1.2.5,
> >>php-5.0.3 & mapserver 4.4.1
> >>
> >>The first thing i did is pipe lwpostgis.sql & spatial_ref_sys.sql into
> >>pgsql.
> >>
> >>I continued to run shp2pgsql on one of the shape files to insert it into
> >>my database with
> >>shp2pgsql -d drainagexxxxx.shp drainage > /tmp/postgis.sql
> >>
> >>I then tried to pipe the /tmp/postgis.sql into postgresql,  but got the
> >>following error...
> >>
> >>BEGIN
> >>NOTICE:  CREATE TABLE will create implicit sequence "drainage_gid_seq"
> >>for serial column "drainage.gid"
> >>CREATE TABLE
> >>                                 addgeometrycolumn
> >>---------------------------------------------------------------------------------------
> >>public.drainage.the_geom SRID:-1 TYPE:MULTILINESTRING DIMS:4
> >>geometry_column fixed:0
> >>(1 row)
> >>
> >>ERROR:  Invalid type in wbk
> >>
> >>
> >
> >Nigel, we have fixed a (Multi)LineString-related bug in shp2pgsql.
> >If you can test a CVS snapshot that would help us release RC4.
> >
> >--strk;
> >
> >
> >
> >
> >>ERROR:  current transaction is aborted, commands ignored until end of
> >>transaction block
> >>ERROR:  current transaction is aborted, commands ignored until end of
> >>transaction block
> >>ERROR:  current transaction is aborted, commands ignored until end of
> >>transaction block
> >>ROLLBACK
> >>
> >>
> >>most of the shape files import fine, there are a couple of types which
> >>give me the above error.
> >>
> >>any help would greatly be appreciated, if need be I can attach the
> >>actual sql file or any other info needed.
> >>
> >>Regards
> >>Nigel Kukard
> >>
> >>
> >
> >
> >
> >
> >
> >>_______________________________________________
> >>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
> >
> >
> 
> --
> Nigel Kukard, PhD CompSc
> (Chief Executive Officer)
> Linux Based Systems Design
> Web: www.lbsd.net          Email: nkukard at lbsd.net
> Tel: (+27) 023 349 8000     Cell: (+27) 082 333 3723
> Fax: (+27) 023 349 1395  Support: 086 747 7600
> Address: LIGT House, 2 Klipdrift Rd, Rawsonville
> Linux Systems Design & Technology Solutions
> 
> 
>   The best language to use is the language that was designed for
>                  what you want to use it for.
> 
> 
> =====================================================================
> 
> Disclaimer
> ----------
> The contents of this message and any attachments are intended
> solely for the addressee's use and may be legally privileged and/or
> confidential information. This message may not be retained,
> distributed, copied or used if you are not he addressee of this
> message. If this message was sent to you in error, please notify
> the sender immediately by reply e-mail and then destroy the message
> and any copies thereof.
> 
> Opinions, conclusions and other information in this message may be
> personal to the sender and is not that of Linux Based Systems Design,
> LinuxRulz or any of it's subsideries, associated companies or
> principals and is therefore not endorsed by Linux Based Systems
> Design or LinuxRulz. Due to e-maill communication being insecure,
> Linux Based Systems Design and LinuxRulz do not guarantee
> confidentiality, security, accuracy or performance of the e-mail.
> Any liability for viruses is excluded to the fullest extent.
> 



> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users