[R-sig-DB] dbWriteTable of RPostgreSQL can't insert data into PostgreSQL Server.

[Tomoaki NISHIYAMA]

Hi,

> On 2011/02/06, at 13:19, Xiaobo Gu wrote:
>>> | 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.
>> It seems there are other problems than encoding, the columns with
>> Chinese character have been removed from the sample data I sent, but
>> the remaining columns still can't get inserted into database server.


If so, you can track down to a single record that prevents
insertion, and present an R transaction showing how it fails.
Including, what you typed into R console, response by R including the
error message and how you know that it is not inserted.

Without real example, there is no way to help as Dirk suggested in  
the previous mail.

At least,
http://r.789695.n4.nabble.com/Package-RPostgreSQL-Problem-with- 
dbWriteTable-td2195653.html#a2221189
is apparently unrelated, as it is clearly the problem of pathname  
transmission, which is not
in current code.
http://code.google.com/p/rpostgresql/issues/detail?id=10&can=1
-- 
Tomoaki NISHIYAMA

Advanced Science Research Center,
Kanazawa University,
13-1 Takara-machi,
Kanazawa, 920-0934, Japan