dbWriteTable(temporary = TRUE, overwrite = TRUE) deletes non-temporary table!

[mgirlich]

It is possible to create a temporary table with the same name as an existing non-temporary table. Unfortunately, with dbWriteTable() this is not possible and the existing table is simply deleted.

 found <- dbExistsTable(conn, name)
  if (found && !overwrite && !append) {
    stop("Table ", name, " exists in database, and both overwrite and",
      " append are FALSE",
      call. = FALSE
    )
  }
  if (found && overwrite) {
    dbRemoveTable(conn, name)
  }

[krlmlr]

Thanks, confirmed.

library(DBI)
con <- DBI::dbConnect(RPostgres::Postgres())

dbWriteTable(con, "my", data.frame(a = 1), overwrite = TRUE)

dbWriteTable(con, "my", data.frame(b = 2), overwrite = TRUE, temporary = TRUE)
dbReadTable(con, "my")
#>   b
#> 1 2

dbRemoveTable(con, "my", temporary = TRUE)
dbReadTable(con, "my")
#> Error: Failed to prepare query : ERROR:  relation "my" does not exist
#> LINE 1: SELECT * FROM  "my"
#>                        ^

dbRemoveTable(con, "my")
#> Error: Failed to fetch row : ERROR:  table "my" does not exist

dbDisconnect(con)

^{Created on 2023-04-01 with reprex v2.0.2}