[STATSGRASS] R-GRASS-Postgres

[Markus Neteler]

Javier,

there is a bug in the old RDBI/RdbiPgSQL library on sourceforge. We have
fixed it and it was included into the new version. But: 
Fetch it from BioConductor, the new RDBI/RdbiPgSQL home.

Remarks and link here:
 http://mpa.itc.it/markus/tmp/rdbi/

Note that the new 1.2 version will cause problems if you load an 
old .RData file (since they change the name of a subfunction).
Workaround unknown.

Hope this helps,

 Markus

PS: Maybe also useful reading for newbies:
http://grass.itc.it/statsgrass/r_and_dbms.html

On Fri, Mar 12, 2004 at 10:45:10PM +0100, javier garcia - CEBAS wrote:
> Hi all;
> I know this is not the most proper place to pose this question. But perhaps 
> some has used these things successfully.
> I'm usin GRASS along with R and Postgres, and really my problem is with the 
> link between Postgres-R. I've written to the developer of the library but I 
> guess he is out of work these days.
> I just would like to know if someone has used R to write tables in Postgres. 
> I'm trying to do it (dbWriteTable() function) but the function not only 
> doesn't writes any data to the table but it also drops the table from the 
> database.
> 
> I'm using it in the way:
> >>>>>>>>>>>>>>> 
> dbWriteTable(conn,sonda.unidata.valores,name=deparse(substitute("pueblaunidatainterp")))
> Error in dbAppendTable.PgSQL.conn(conn, name, data) :
>         Table "pueblaunidatainterp" does not exist
> >>>>>>>>>>>>>>>>
> 
> And I can asure that the table existed but it is erased with the funtion.
> 
> If now one knows anything about this, forgive to ask this here.
> 
> Thanks and best wishes,
> 
> Javier
> 
> _______________________________________________
> statsgrass mailing list
> statsgrass at grass.itc.it
> http://grass.itc.it/mailman/listinfo/statsgrass

-- 
Markus Neteler     <neteler itc it>       http://mpa.itc.it
ITC-irst -  Centro per la Ricerca Scientifica e Tecnologica
MPBA - Predictive Models for Biol. & Environ. Data Analysis
Via Sommarive, 18        -       38050 Povo (Trento), Italy