[BioC] problem with RdbiPgsql and R

[javier garcia - CEBAS]

----------  Mensaje reenviado  ----------

Subject: Re: [BioC] problem with RdbiPgsql and R
Date: Thu, 22 Apr 2004 11:54:19 +0200
From: javier garcia - CEBAS <rn001 at cebas.csic.es>
To: Robert Gentleman <rgentlem at 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,name=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 at stat.math.ethz.ch
> > https://www.stat.math.ethz.ch/mailman/listinfo/bioconductor