R help - Jan 2012 - dbWriteTable(con, access_log, overwrite = F).....

I am new to R.

My goal is to make a crosstable from a Apache access.log, which I want
to load into PostgreSQL database at first to
learn more abour R and DBI and datatypes. When the I have got the
access.log in the database I will try to make the
crosstable!

Trying to load the Apache access.log into PostgreSQL I get an error.

dbWriteTable(con, access_log, overwrite = F);

returns

Error in .Internal(is.vector(x, mode)) : 'x' is missing?

Thanks

Poul

Poul Kristensen
IT-Konsulent / Consultant


Det Kongelige Bibliotek | The Royal Library IT-afdelingen |
Information Technology

P.O. Box 2149 | DK-1016 K?benhavn K
tel +45 3347 4586 | pok at kb.dk | www.kb.dk


Bes?gsadresse | Visiting address | S?ren Kierkegaards Plads 1 Leveringsadresse
Delivery address | Christians Brygge 8 | 1219 K?benhavn K

EAN 5798 000 79 52 97 | Bank 8109 101111-4 | CVR 28 98 88 42 IBAN
DK9881090001011114 | Swiftcode JYBADKKK

Le lundi 16 janvier 2012 ? 14:14 +0100, Poul Kristensen a ?crit
:
> I am new to R.
> 
> My goal is to make a crosstable from a Apache access.log, which I want
> to load into PostgreSQL database at first to
> learn more abour R and DBI and datatypes. When the I have got the
> access.log in the database I will try to make the
> crosstable!
> 
> Trying to load the Apache access.log into PostgreSQL I get an error.
> 
> dbWriteTable(con, access_log, overwrite = F);
> 
> returns
> 
> Error in .Internal(is.vector(x, mode)) : 'x' is missing?
I don't know anything about this function, but from its documentation,
it seems you forgot to pass a name for the table. Maybe something like
that would work:
dbWriteTable(con, "access_log", access_log, overwrite = F)


Cheers