[R-sig-DB] Error in postgresqlExecStatement...RS-DBI driver: (could not Retrieve the result...)

[Rex Hu]

Hi all!

I am a total newb in database programming, but unfortunately, I am  
working on a project that requires database programming using R. I  
hope that some one could help me about this. Thank you all in advance!

I ran into this error when I was trying to run an R program written by  
someone else. It occurs when executing this 'big loop' (the R code of  
this loop is in the attachment). I have absolutely no clue what is  
going on.

The environment where I ran the program is Red Hat Enterprise Linux 6,  
and PostgreSQL 8.4.7. R version is  2.12.1.

The following are error messages.

64490 :class(mydata):  data.frame
    cleaning.out.cols: geofencename, geofencereason
    prod(u.gfn == ""): 0
    prod(u.gfr == ""): 0
    dim(mydata): 185 7
    Creating hourflag, odoflag, stateflag...done.
    Appending them to the data.frame...done.
    Sum:: hourflag: 10 , odoflag: 10 , stateflag: 12 , hrOdoflag: 10
    Starting hrodoflag.index loop...
    hrodoflag.index loop finished.
Error in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver: (could not Retrieve the result : ERROR:  relation  
"public.tmptable" already exists
)
In addition: Warning messages:
1: In dir.create(datadumpdir, showWarnings = TRUE, recursive = TRUE,  :
  '/scratch/kan/datadump' already exists
2: In dir.create(misclwritedir, showWarnings = TRUE, recursive =  
TRUE,  :
  '/scratch/kan/work/bordercrossing/miscl/AU08_100301' already exists
3: In dir.create(datawritedir, showWarnings = TRUE, recursive = TRUE,  :
  '/scratch/kan/work/bordercrossing/data/cevaAU08_100301' already exists
Error in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver: (could not Retrieve the result : ERROR:  relation  
"public.tmptable" does not exist
)
In addition: Warning message:
In postgresqlQuickSQL(conn, statement, ...) :
  Could not create executeCREATE TABLE "public.tmptable"
( "id_tb100301trp" bigint,
    "bridge_new" text,
    "tripscore" float8,
    "stflag" float8,
    "hrflag" float8,
    "odflag" float8
)
Error in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver: (could not Retrieve the result : ERROR:  relation  
"public.tmptable" does not exist
)
In addition: Warning message:
In postgresqlQuickSQL(conn, statement, ...) :
  Could not create executeCOPY public.tmptable FROM '/tmp/ 
rpsql.G19577' WITH CSV HEADER QUOTE AS '"'
Error in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver: (could not Retrieve the result : ERROR:  relation  
"public.tmptable" does not exist
)
In addition: Warning message:
In postgresqlQuickSQL(conn, statement, ...) :
  Could not create executeUPDATE  au08_100301.tb100301trp  SET   
bridge_new  =  public.tmptable.bridge_new FROM  public.tmptable
WHERE  au08_100301.tb100301trp.id_tb100301trp  =   
public.tmptable.id_tb100301trp ;
Error in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver: (could not Retrieve the result : ERROR:  relation  
"public.tmptable" does not exist
)
In addition: Warning message:
In postgresqlQuickSQL(conn, statement, ...) :
  Could not create executeUPDATE  au08_100301.tb100301trp  SET   
tripscore  =  public.tmptable.tripscore FROM public.tmptable
WHERE  au08_100301.tb100301trp.id_tb100301trp  =   
public.tmptable.id_tb100301trp ;
Error in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver: (could not Retrieve the result : ERROR:  relation  
"public.tmptable" does not exist
)
In addition: Warning message:
In postgresqlQuickSQL(conn, statement, ...) :
  Could not create executeUPDATE  au08_100301.tb100301trp  SET   
stflag  =  public.tmptable.stflag FROM public.tmptable
WHERE  au08_100301.tb100301trp.id_tb100301trp  =   
public.tmptable.id_tb100301trp ;
Error in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver: (could not Retrieve the result : ERROR:  relation  
"public.tmptable" does not exist
)
In addition: Warning message:
In postgresqlQuickSQL(conn, statement, ...) :
  Could not create executeUPDATE  au08_100301.tb100301trp  SET   
hrflag  =  public.tmptable.hrflag FROM public.tmptable
WHERE  au08_100301.tb100301trp.id_tb100301trp  =   
public.tmptable.id_tb100301trp ;



***********************************************
Hu, Zhengyu (Rex)
Department of Statistics
The Ohio State University
Columbus, OH 43210