[Tile-serving] [openstreetmap/osm2pgsql] Should we issue DROP TABLE ... CASCADE (#687)

Paul Norman notifications at github.com
Wed Feb 8 17:19:37 UTC 2017


I have a setup where I have a view on a rendering table, and `osm2pgsql --create` fails when dropping tables with

```
Setting up table: pier_line_raw
Osm2pgsql failed due to ERROR: DROP TABLE IF EXISTS pier_line_raw failed: ERROR:  cannot drop table pier_line_raw because other objects depend on it
DETAIL:  view pier_line depends on table pier_line_raw
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
```

Given that `--create` is a destructive operation to previous data in the DB, I think we should `DROP TABLE ... CASCADE`

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/687
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170208/afb15a6d/attachment.html>


More information about the Tile-serving mailing list