search

Stephen-McDaniel / rpostgresql

This repository is an export of the final version from the retired Google Code system (code.google.com/p/rpostgresql).
0 stars 0 forks source link

dbWriteTable not functioning correctly #7

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 

dbWriteTable method is not functioning properly. It starts by creating the
database table but it doesn't populates it with data from the inputed df.
The following rcode produces:

dbWriteTable(pg.conn,"test_cars",cars)

> Error in postgresqlExecStatement(conn, statement, ...) : 
  RS-DBI driver: (could not Retrieve the result : ERROR:  could not open
file "C:DOCUME~1JOO~1DEFINI~1TempRtmpVtwbDRsdbi29f35ee8" for reading:
Invalid argument)

[1] FALSE
Warning message:
In postgresqlWriteTable(conn, name, value, ...) :
  could not load data into table 

Please notice that the path in the error message seems to have some problem.
I'm using R 2.8.0 (2008-10-20) on Windows XP Pro SP3.

Original issue reported on code.google.com by joao...@gmail.com on 9 Oct 2009 at 10:04

GoogleCodeExporter commented 9 years ago 
That looks like a Windows issue --- see the various regressions tests we run
that do include dbWriteTableTest.R.  And I just modified it to also check for 
table
names with underscores, and that passes too.  

So this issue is not reproducible at my end.

Original comment by dirk.eddelbuettel on 9 Oct 2009 at 10:28

GoogleCodeExporter commented 9 years ago 
I later realised that the dbWriteTableTest.R was only recently added to SVN -- 
my bad.
Still, I am unable to replicate this issue.

Original comment by dirk.eddelbuettel on 10 Oct 2009 at 3:47

GoogleCodeExporter commented 9 years ago 
Should have been fixed in 0.1-7

Original comment by tomoa...@kenroku.kanazawa-u.ac.jp on 17 Oct 2010 at 9:40