Skip site navigation (1) Skip section navigation (2)

Error in postgresqlExecStatement...RS-DBI driver: (could not Retrieve the result...)

From: Zhengyu Hu <hu(dot)280(at)buckeyemail(dot)osu(dot)edu>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Error in postgresqlExecStatement...RS-DBI driver: (could not Retrieve the result...)
Date: 2011-02-09 16:14:38
Message-ID: 3A3B49A3B53F2840A5C1EABD709695FC5530AF46@BL2PRD0103MB039.prod.exchangelabs.com (view raw or flat)
Thread:
Lists: pgsql-novice
 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

Attachment: loop.R
Description: application/octet-stream (10.0 KB)

pgsql-novice by date

Next:From: Caradoc JonesDate: 2011-02-09 16:33:25
Subject: Data Model Protection?
Previous:From: l1Date: 2011-02-09 15:36:46
Subject: how to get logger to not break up syslog messages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group