Opened 8 years ago

Last modified 4 years ago

#2935 new enhancement

shp2pgsql: There should be a way to add a delete table statement even when just preparing the DDL

Reported by: jimktrains Owned by: pramsey
Priority: medium Milestone: PostGIS Fund Me
Component: loader/dumper Version: 2.1.x
Keywords: shp2pgsql Cc:

Description

Currently, -p, -a, and -d overwrite one another. It is sometimes useful to be able to specify DDL create with a delete statement.

Change History (10)

comment:1 by jimktrains, 8 years ago

My personal preference would be to make -d (or something else, -r?) imply adding a drop statement, and not imply importing, and make it error if -a is specified.

comment:2 by robe, 8 years ago

Component: postgisloader/dumper
Owner: changed from pramsey to mcayland

comment:3 by pramsey, 8 years ago

Milestone: PostGIS 2.1.5PostGIS 2.1.6

comment:4 by pramsey, 8 years ago

Milestone: PostGIS 2.1.6PostGIS 2.2.0

comment:5 by robe, 8 years ago

Owner: changed from mcayland to robe

comment:6 by robe, 7 years ago

Milestone: PostGIS 2.2.0PostGIS 2.3.0

comment:7 by robe, 6 years ago

Milestone: PostGIS 2.3.0PostGIS 2.4.0

comment:8 by robe, 5 years ago

Owner: changed from robe to pramsey

-p should first do a

DROP TABLE .. IF EXISTS

comment:9 by robe, 5 years ago

Milestone: PostGIS 2.4.0PostGIS 2.5.0

In thinking about this more, I think making -p do a DROP may not be the best thing as you might want to get an error if you try to prepare an already loaded table.

So I'm pushing this as I think it needs more thought.

comment:10 by komzpa, 4 years ago

Milestone: PostGIS 2.5.0PostGIS Fund Me
Note: See TracTickets for help on using tickets.