[postgis-users] Possible bug in shp2psql

[christian.schuster at rsag.ch]

Hi list,

I have a shape file which I could convert to a SQL statement file with
shp2pgsql. The surprise came as I wanted to insert data into PostgreSQL. It
was not possible because the data type of one column was wrong. Instead of
int8 it was declared as int4. I am not an expert with shapefiles and
shp2pgsql at all. So, I am not sure where the problem is. After I changed
the int4 to int8 of the column PARCEL in the SQL-file I could insert the
data.

I attached the shape file as well as the SQL file which shp2pgsql created.

System:
Win2000
Cygwin
PostgreSQL-7.3.1-1
PostGIS-CVS (02-10-2003)


(See attached file: test.sql)(See attached file: test.shp)(See attached
file: test.shx)(See attached file: test.dbf)
Regards,


Christian Schuster

Rudolf Schuster AG
Postfach 277
CH - 3000 Bern 11

http://www.rsag.ch
++41 31 348 05 30
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.sql
Type: application/octet-stream
Size: 2898 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030212/5809272e/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.shp
Type: application/octet-stream
Size: 576 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030212/5809272e/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.shx
Type: application/octet-stream
Size: 236 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030212/5809272e/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.dbf
Type: application/vnd.lotus-approach
Size: 1896 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030212/5809272e/attachment.bin>