[R] Add primary key to sqlite table

2014-02-26 Thread Christian Oswald
Hello, is it possible to add a primary key to a sqlite table with Rsqlite? Without create a complex query string? I have tried dbWriteTable but don't found an option to define a field as primary key. Has someone suggestions? Thanks, Christian __ R-h

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Christian Oswald
I have the 5.5 Server but in the opt directory are only two files libmysql.dll and libmysql.lib Christian Am 06.02.2014 16:29, schrieb Gabor Grothendieck: > On Thu, Feb 6, 2014 at 3:52 PM, Christian Oswald > wrote: >> I understand, but in my case the R-Library is in my user-fold

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Christian Oswald
, schrieb Duncan Murdoch: > On 06/02/2014 1:39 PM, Christian Oswald wrote: >> Hello, >> >> how can I install it on a wrong place? >> >> "install.packages("RMySQL",type=source) don't work correct? > > Many Windows users have R installed in &quo

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Christian Oswald
Hello, how can I install it on a wrong place? "install.packages("RMySQL",type=source) don't work correct? Christian Am 06.02.2014 09:28, schrieb Duncan Murdoch: > On 06/02/2014 8:43 AM, Christian Oswald wrote: >> Hello, >> >> I also don't found

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Christian Oswald
Hello, I also don't found a solution for this problem. RMySQL works very well under Linux but not under Windows. You can try RODBC. Christian Am 05.02.2014 14:37, schrieb Peretz, Eliran: > > Hi , > > I read your post and followed your instructions but still couldn't install > RMySQL by getting

Re: [R] Problem connecting to database via RPostgreSQL/RS-DBI: "could not connect" error

2014-02-03 Thread Christian Oswald
Hello, what's your operating system? Windows? Perhaps you don't have an account administrator in the postgresql. libpg is not a R-library it's system dependent. (ubuntu "apt-get install libpg-dev") Christian Am 31.01.2014 22:40, schrieb andrewH: > In the description section of the RPostg

[R] Memory usage

2008-04-24 Thread Christian Oswald
Hello, I have aggregate a data.frame from 16MB (Object size). After some minutes I get the error message "cannot allocate vector of size 64.5MB". My computer has a physical memory of 4GB under Windows Vista. I have test the same command on another computer with the same OS and 2GB RAM. In nearly