d_hrishikesh at yahoo.com
Sun Apr 3 18:50:07 CEST 2005
My sincere apologies i have posted this question on
BioC rather than R list.
I want to install REmbeddedPostgres; it needs source,
finding source is not a problem. I have a debian linux
box, i had installed Postgres via apt-get; i have
RdbiPgSQL installed so i have to get postgres-dev
version. Now i want to use REmbeddedPostgres! which
requires source, does installing source means another
installation of postgres?! and i have to recreate
DB's,load data etc!
Which version of source should i get
--- Sean Davis <sdavis2 at mail.nih.gov> wrote:
> On Mar 24, 2005, at 3:29 PM, Hrishikesh Deshmukh
> > Hi All,
> > library(RdbiPgSQL)
> > #Connect to DB
> > conn <- dbConnect(PgSQL(), host = "localhost",
> > = "^^^^^",user="&&&&",password="#####")
> > tt <- dbSendQuery(conn,"SELECT * FROM table WHERE
> > signalrawintensity >= 200 and signalrawintensity
> > 20000 and pm_mm_other >=0")
> > mytt <- dbGetResult(tt)
> > This works fine but when i run:
> > tt1 <- dbSendQuery(conn,"Create table trial as
> > * FROM all254gnxdt1 WHERE signalrawintensity >=
> > and signalrawintensity <= 20000 and pm_mm_other
> > rd<-dbReadTable(conn,trial)
> > I get this error:
> > mylin <- dbGetResult(lin)
> You need to do:
> rd <- dbReadTable(conn,"trial")
> Note the quotes.
> The "did not produce any tuples" is a bit misleading
> at times. I have
> found that usually means that I messed up a command
> (bad SQL, etc), so
> it usually means go back to check your query.
> Hope that helps.
Show us what our next emoticon should look like. Join the fun.
More information about the Bioconductor