Proposed fix for issue: Error: host must be a single element of type 'character'.

[reinout91]

Unfortunately I ran into the error: Error: host must be a single element of type 'character'. This occurred in my install on R version 4.0.3, and Postgresql 11.

I resolved this issue locally by changing the functions in R/sp_postgresql_functions.R to:

#' @importFrom DBI dbGetInfo .sp_pg_display_name <- function(connection) { db_info <- DBI::dbGetInfo(connection) return(paste(db_info[["dbname"]], db_info[["username"]], db_info[["host"]], sep = '_')) }

#' @importFrom DBI dbGetInfo .sp_pg_host_name <- function(connection) { db_info <- DBI::dbGetInfo(connection) return(paste(db_info[["dbname"]], db_info[["username"]], db_info[["host"]], sep = '_')) }

[znmeb]

Thanks!! It'll take me a day or so to get all of this back up and running - I haven't touched it since the end of February 2020.