[postgis-users] Error while importing data

[Darren Houston]

Hi Nigel,

Tell us what your problem is and paste the error messages and any other 
information you think is pertinent. What are you doing when you receive the 
constraint violation error messages? I am at work for another hour, so I can 
look at it if you get back to me soon.

Darren H.

On March 13, 2005 08:10 am, 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?
>
> 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.