dbWriteTable not functioning correctly

[GoogleCodeExporter]

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]

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]

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

• Changed state: WontFix
• Added labels: Priority-Low, Type-Other
• Removed labels: Priority-Medium, Type-Defect

[GoogleCodeExporter]

Should have been fixed in 0.1-7

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

• Changed state: Fixed