<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi, below error message, attached shapefiles<br>
<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:strk@refractions.net">strk@refractions.net</a> wrote:
<blockquote cite="mid20050314082306.GC93767@freek.keybit.net"
type="cite">
<pre wrap="">On Sun, Mar 13, 2005 at 03:10:23PM +0000, Nigel Kukard wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
commands i used are.. (cvs snapshot of postgis-1.0.0, RCSID: $Id:
shp2pgsql.c,v 1.81 2005/03/08 11:06:33 strk Exp $)<br>
<br>
shp2pgsql -a -D 2327BD_AIR_TRANSPORT_AREA_ALLFEATTYPES.shp all >
/tmp/air_transport.sql<br>
psql -U postgres all < /tmp/air_transport.sql<br>
<br>
here is the error....<br>
<br>
BEGIN<br>
ERROR: new row for relation "air_transport_area" violates check
constraint "enforce_dims_the_geom"<br>
CONTEXT: COPY air_transport_area, line 1: "12006587 12006587
LANDING STRIP AREA 2327BD A 0 \N
000000000000000000000001 0 \N MDP_2 0 0
20020522 ..."<br>
ROLLBACK<br>
<br>
<br>
attached is the shapefiles i am trying to import.<br>
<br>
Thanks for your help!!!<br>
<br>
Regards<br>
Nigel<br>
<blockquote cite="mid20050314082306.GC93767@freek.keybit.net"
type="cite">
<pre wrap="">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;
</pre>
<blockquote type="cite">
<pre wrap="">Regards
Nigel
<a class="moz-txt-link-abbreviated" href="mailto:strk@refractions.net">strk@refractions.net</a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Thu, Mar 10, 2005 at 06:00:20AM +0000, Nigel Kukard wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">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;
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</blockquote>
</blockquote>
<br>
</body>
</html>