dbWriteTable of RPostgreSQL can't insert data into PostgreSQL Server.

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