[R-sig-DB] dbWriteTable of RPostgreSQL can't insert data into PostgreSQL Server.
Xiaobo Gu
gux|@obo1982 @end|ng |rom gm@||@com
Sat Feb 5 16:53:13 CET 2011
Hi,
This problem was reported discussed on May 2010, but it seems it was
not resolved at least in version 0.1.7 of RPostgreSQL.
I have seen the similar problem as reported
by:http://r.789695.n4.nabble.com/Package-RPostgreSQL-Problem-with-dbWriteTable-td2195653.html#a2221189
> sessionInfo()
R version 2.12.1 (2010-12-16)
Platform: x86_64-pc-mingw32/x64 (64-bit)
locale:
[1] LC_COLLATE=Chinese (Simplified)_People's Republic of China.936
LC_CTYPE=Chinese (Simplified)_People's Republic of China.936
[3] LC_MONETARY=Chinese (Simplified)_People's Republic of China.936
LC_NUMERIC=C
[5] LC_TIME=Chinese (Simplified)_People's Republic of China.936
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] RPostgreSQL_0.1-7 DBI_0.2-5
> traceback()
No traceback available
And I have some more information:
1. If there are text data with Chinese character, then data will not
be inserted into database server even there is only one column of the
dataframe.
2. I can send you the sample data which can't be inserted.
Regards,
Xiaobo Gu
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ddwe.RData
Type: application/octet-stream
Size: 11082 bytes
Desc: ddwe.RData
URL: <https://stat.ethz.ch/pipermail/r-sig-db/attachments/20110205/c292c261/attachment.obj>
More information about the R-sig-DB
mailing list