Cannot drop puechcirc as a pgtraj

[basille]

Same setup as #37 :

library("adehabitatLT")
data(puechcirc)
attr(puechcirc, "proj4string") <- CRS("+init=epsg:27573")  # This is Lambert III projection

library("rpostgisLT")
drv <- dbDriver("PostgreSQL")
con <- dbConnect(drv, dbname = "<db>", host = "localhost", user = "<user>", password = "<pwd>")
ltraj2pgtraj(con, puechcirc)

pgtrajDrop fails on it:

pgtrajDrop(con, "puechcirc")

RS-DBI driver: (could not Retrieve the result : ERROR:  cannot drop view parameters_puechcirc because other objects depend on it
DETAIL:  materialized view step_geometry_shiny_puechcirc depends on view parameters_puechcirc
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
). Rolling back transaction
Error in value[[3L]](cond) : Returning from function

Dropping the entire schema works…

---

R info:

> sessionInfo()
R version 3.3.3 (2017-03-06)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Debian GNU/Linux 9 (stretch)

locale:
[1] C

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
 [1] shiny_1.1.0         rpostgisLT_0.6.0    rpostgis_1.4.0-1   
 [4] RPostgreSQL_0.6-2   DBI_1.0.0           adehabitatLT_0.3.23
 [7] CircStats_0.2-4     boot_1.3-18         MASS_7.3-45        
[10] adehabitatMA_0.3.12 ade4_1.7-11         sp_1.3-1           
[13] cowsay_0.6.0        basr_0.11          

loaded via a namespace (and not attached):
 [1] sf_0.6-3           lattice_0.20-34    mapview_2.4.0      colorspace_1.3-2  
 [5] viridisLite_0.3.0  htmltools_0.3.6    stats4_3.3.3       yaml_2.1.19       
 [9] base64enc_0.1-3    rlang_0.2.1        R.oo_1.22.0        e1071_1.6-8       
[13] later_0.7.3        R.utils_2.6.0      fortunes_1.5-4     foreach_1.4.4     
[17] stringr_1.3.1      rgeos_0.3-28       munsell_0.5.0      raster_2.6-7      
[21] R.methodsS3_1.7.1  htmlwidgets_1.2    codetools_0.2-15   httpuv_1.4.4.1    
[25] crosstalk_1.0.0    class_7.3-14       shinyWidgets_0.4.3 gdalUtils_2.0.1.14
[29] Rcpp_0.12.17       xtable_1.8-2       promises_1.0.1     scales_0.5.0.9000 
[33] classInt_0.2-3     satellite_1.0.1    webshot_0.5.0      leaflet_2.0.1     
[37] jsonlite_1.5       mime_0.5           rmsfact_0.0.3      png_0.1-7         
[41] digest_0.6.15      stringi_1.2.3      grid_3.3.3         rgdal_1.3-2       
[45] tools_3.3.3        magrittr_1.5       spData_0.2.9.0     lubridate_1.7.4   
[49] iterators_1.0.9    R6_2.2.2           units_0.6-0        compiler_3.3.3    

PostgreSQL/PostGIS info:

> dbGetQuery(con, "SELECT version();")
                                                                                                           version
1 PostgreSQL 9.6.9 on x86_64-pc-linux-gnu (Debian 9.6.9-2.pgdg+1), compiled by gcc (Debian 7.3.0-18) 7.3.0, 64-bit

> dbGetQuery(con, "SELECT PostGIS_Version();")
                        postgis_version
1 2.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1