Advertisement
Guest User

Untitled

a guest
May 1st, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. drv <- dbDriver("PostgreSQL")
  2. con <- dbConnect(drv, dbname="dbname",host="host",port=5432,user="usr",password="pwd")
  3.  
  4. vSQLDF <- sqldf(vSQL, connection=con)
  5.  
  6. Error in dbPreExists && !overwrite : invalid 'x' type in 'x && y'
  7.  
  8. > sessionInfo()
  9. R version 2.15.2 (2012-10-26)
  10. Platform: x86_64-pc-linux-gnu (64-bit)
  11.  
  12. locale:
  13. [1] LC_CTYPE=cs_CZ.UTF-8 LC_NUMERIC=C LC_TIME=en_GB.UTF-8 LC_COLLATE=cs_CZ.UTF-8 LC_MONETARY=en_GB.UTF-8
  14. [6] LC_MESSAGES=en_US.UTF-8 LC_PAPER=C LC_NAME=C LC_ADDRESS=C LC_TELEPHONE=C
  15. [11] LC_MEASUREMENT=en_GB.UTF-8 LC_IDENTIFICATION=C
  16.  
  17. attached base packages:
  18. [1] tcltk stats graphics grDevices utils datasets methods base
  19.  
  20. other attached packages:
  21. [1] lattice_0.20-13 sqldf_0.4-6.4 RSQLite.extfuns_0.0.1 RSQLite_0.11.2 chron_2.3-43 gsubfn_0.6-5
  22. [7] proto_0.3-10 RPostgreSQL_0.3-3 DBI_0.2-5
  23.  
  24. loaded via a namespace (and not attached):
  25. [1] grid_2.15.2 tools_2.15.2
  26.  
  27. PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit
  28.  
  29. if (request.con) dbPreExists <- attr(connection, "dbPreExists")
  30.  
  31. dbPreExists <- attr(connection, "dbPreExists") #see error gets thrown.
  32.  
  33. debug(sqldf) # then repeat operation
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement