Allow PostGIS table overwrite updates via truncate

[mpfister]

ogr2ogr updates a PostGIS table by first running a DROP CASCADE on the table, then recreating it. If there are views on the table, they are dropped by the CASCADE. Is it possible to update a table by instead running TRUNCATE on the table to empty it, then filling it with new records? I've tried combinations of the current options and don't think you can accomplish this result presently.

[Even Rouault]

You can try: 'ogrinfo pg:dbname=XXXX -sql "truncate table foo"' before running ogr2ogr -append

[mpfister]

Yes, I truncate with psql already, though that's a handy trick to use ogrinfo.

[Even Rouault]

trunk r26055 "PG: add a OGR_TRUNCATE configuration option that can be used as an alternative to the -overwrite flag of ogr2ogr, but that avoids DROP TABLE ... CASCADE which destroys views based on the tables (#5091)"