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=de parse(substitute("sondalapueblainterp"))) ---- 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,

>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=d eparse(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@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

---------- Mensaje reenviado ---------- Subject: Re: [BioC] problem with RdbiPgsql and R Date: Thu, 22 Apr 2004 11:54:19 +0200 From: javier garcia - CEBAS <rn001@cebas.csic.es> To: Robert Gentleman <rgentlem@jimmy.harvard.edu> Hi Robert; I just wrote that because that's the way it appears in the documentation. Now, as you've told me, it works right. Thanks. The only thing I'm missing is that I'm seeing that a column of data that was "timestamp with time zone" in the source table of postgres, and is the same column I want to upload back to a new table in the database, has become a "text" column. (well, I can output the postgres table as ASCII file and COPY it back to a new table in Postgres) Thanks and regards, Javier El Mi? 21 Abr 2004 22:04, escribi?: > On Wed, Apr 21, 2004 at 08:51:07PM +0200, javier garcia - CEBAS wrote: > > 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,nam e=depar > >se(substitute("sondalapueblainterp"))) ---- > > where "sondalapueblainterp"is the name of table I want to upload the > > results > > Well first off you don't need the deparse(substitute()) stuff on on > the name argument > you want to just put the name of the table there (not sure why you > wanted deparse substitite), but it will do something a bit odd > > > 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@stat.math.ethz.ch > > https://www.stat.math.ethz.ch/mailman/listinfo/bioconductor