Question: problem with RdbiPgsql and R
0
gravatar for javier garcia - CEBAS
15.5 years ago by
javier garcia - CEBAS30 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,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,
rdbi • 394 views
ADD COMMENTlink modified 15.5 years ago • written 15.5 years ago by javier garcia - CEBAS30
Answer: problem with RdbiPgsql and R
0
gravatar for John Zhang
15.5 years ago by
John Zhang2.9k
John Zhang2.9k 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,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
ADD COMMENTlink written 15.5 years ago by John Zhang2.9k
Answer: problem with RdbiPgsql and R
0
gravatar for javier garcia - CEBAS
15.5 years ago by
javier garcia - CEBAS30 wrote:
---------- 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
ADD COMMENTlink written 15.5 years ago by javier garcia - CEBAS30
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 203 users visited in the last hour