Opened 16 years ago

Last modified 16 years ago

#29 closed defect (fixed)

shp2pgsql -n imports deleted rows

Reported by: richard.greenwood Owned by:
Priority: medium Milestone:
Component: postgis Version:
Keywords: Cc:

Description

If the source DBF has rows that are flagged for deletion they are still inserted into the postgres table.

The attached 'example.DBF' had four rows, two of which were subsequently deleted. When viewed Excel, MapInfo, ArcView, etc. only two rows show. However when imported to PostgreSQL via shp2pgsql -n all 4 rows are imported and displayed. What version of the product are you using? On what operating system? PostGIS 1.3.3 on Windows XP.

Thanks, Richard Greenwood richard.greenwood at gmail dot com

Change History (5)

comment:1 by pramsey, 16 years ago

Attached patch against 1.3 branch should fix it, please test.

comment:2 by richard.greenwood, 16 years ago

Thanks Paul. The patch appears to have done the trick, at least in my limited testing.

by richard.greenwood, 16 years ago

Attachment: example.DBF​ added

​http://postgis.googlecode.com/issues/attachment?aid=1602057575257912817&name=example.DBF

comment:3 by pramsey, 16 years ago

<i>(No comment was entered for this change.)</i>

by richard.greenwood, 16 years ago

Attachment: dbfdel.patch​ added

​http://postgis.googlecode.com/issues/attachment?aid=4669656992813152563&name=dbfdel.patch

Note: See TracTickets for help on using tickets.