[BioC] problem with RdbiPgsql and R

John Zhang jzhang at jimmy.harvard.edu
Thu Apr 22 15:10:54 CEST 2004


>Hello;
>I'm using the contributing package to connect Postgres and R.
>I can read data from the database correctly, but when I try to write data to 
>the database I find and error:
>
>The sintax I'm using is:
>----
>dbWriteTable.PgSQL.conn(conn,sonda.puebla.valores.interpolados,name=deparse(sub
stitute("sondalapueblainterp")))


I will look into this and let you know what the problem might be. Thank you for 
reporting.


>----
>where "sondalapueblainterp"is the name of table I want to upload the results  
>from R and sonda.puebla.valores.interpolados is the dataframe.  and I've 
>updated to the last available version of Rdbi and Rdbi.PgSQL packages because 
>I had the samne problem with the previous one. The problem is that appears 
>one message saying that the table doesn't exists and I'm absolutely sure that 
>the table exists.
>I guess that some one is using this succesfully.
>
>My versions are:
>postgres 7.4
>R 1.8.1
>Rdbi 1.0.2
>RdbiPgsql 1.0.2
>
>Thanks and best regards,
>
>_______________________________________________
>Bioconductor mailing list
>Bioconductor at stat.math.ethz.ch
>https://www.stat.math.ethz.ch/mailman/listinfo/bioconductor

Jianhua Zhang
Department of Biostatistics
Dana-Farber Cancer Institute
44 Binney Street
Boston, MA 02115-6084



More information about the Bioconductor mailing list