[postgis-users] Error while importing data

[strk at refractions.net]

On Fri, Mar 11, 2005 at 09:31:25AM +0000, Nigel Kukard wrote:
> Hi Strk,
> 
> cvs seems to fix the multiline string bug...
> 
> not sure if this is also related but i get hundreds of these errors...
> 
> help would be greatly appreciated...

Could you send the produced .sql file and/or the input shapefile ?
Also, which architecture are you running shp2pgsql on ?

--strk;

> 
> 
> You are now connected to database "all".
> NOTICE:  CREATE TABLE will create implicit sequence
> "boundary_line_gid_seq" for serial column "boundary_line.gid"
> CREATE TABLE
>                                     addgeometrycolumn
> --------------------------------------------------------------------------------------------
> public.boundary_line.the_geom SRID:-1 TYPE:MULTILINESTRING DIMS:4
> geometry_column fixed:0
> (1 row)
> 
> BEGIN
> ERROR:  new row for relation "boundary_line" violates check constraint
> "enforce_dims_the_geom"
> CONTEXT:  COPY boundary_line, line 1: "15238677 #005:134087     STATE
> FOREST    LINE    3227CA  A       0
>        \N      000000000000000000000001        0       \N      RSWART
> 0       0       200201..."
> ROLLBACK
> BEGIN
> ERROR:  new row for relation "boundary_line" violates check constraint
> "enforce_dims_the_geom"
> CONTEXT:  COPY boundary_line, line 1: "12845197 FORT PATO
> CONSERVATION    LINE    3227DC  A       0
>        \N      000000000000000000000001        0       \N      RSWART
> 0       0       20020621..."
> ROLLBACK
> BEGIN
> ERROR:  new row for relation "boundary_line" violates check constraint
> "enforce_dims_the_geom"
> CONTEXT:  COPY boundary_line, line 1: "8291673  #001:111115535
> CONSERVATION    LINE    3227DD  A       0
>        \N      000000000000000000000002        20021219        \N
> MDP_2   0       ..."
> ROLLBACK
> 
> 
> 
> 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