April 2008 - users-list

[MonetDB-users] COPY INTO of data containing hebrew letters
by ewilde 16 Apr '08

16 Apr '08

hello again. now i have another problem. following your suggestion of using COPY INTO for the migration of my database from MSSql to MonetDB5, i indeed succeeded in copying some tables, enjoying very good performances (for example, one table with ~8 millions of records in ~13 seconds). the new problem i'm facing now is that using COPY INTO for data with hebrew letters ends up with error. i tried to supply COPY INTO a UNICODE enoded file, but than i have not succeeded in defining the tuple and … [View More]

2 1

Re: [MonetDB-users] how to completely remove the MonetDB5installation
by ewilde 16 Apr '08

16 Apr '08

hello! thanks for the latest info. i indeed found all the stuff in %APPDATA%, and i removed it, and the MonetDB5 has come back to life again. if you think i may be able to supply more info about that bug i described in the first place, don't hesitate to contact me. ewilde.

1 0

[MonetDB-users] Sorted materialized views
by Nils Grimsmo 16 Apr '08

16 Apr '08

Hello, all! I am about to prototype something, and it would be convenient to use SQL to throw it together quickly to see if it flies. I downloaded MonetDB yesterday, so I am quite fresh :-) I have a table with a set of columns, and the like to have a few materialized views or projections (or whatever you DB people call it ;-)) sorted on different columns. The views may also have selection, I am not sure yet. And given problem (a data query), I use some statistics to decide which sorting … [View More]

3 4

Re: [MonetDB-users] Trouble connecting - Invalid credentials
by kykim_lists＠mac.com 16 Apr '08

16 Apr '08

I found this subject in the archives, and I am having the same problem I am running on Mac OS X 10.4.11 I built MonetDB from source from MonetDB-Feb2008-SuperBall I am new to MonetDB, so please forgive any ignorance.. Here's what I did: > monetdb create foo # create the db > mserver5 --dbname=foo --dbinit="include sql;" # start the db > ./mclient -lsql sql>CREATE USER "bar" WITH PASSWORD 'password' NAME 'Foobar User' SCHEMA "sys"; sql>CREATE SCHEMA "bar" … [View More]

3 6

[MonetDB-users] fail to connect via merovingian
by McKennirey.Matthew 16 Apr '08

16 Apr '08

2 2

Re: [MonetDB-users] how to completely remove the MonetDB5installation
by ewilde 14 Apr '08

14 Apr '08

the operationg system i want to completely remove MonetDB5 from is: windows server 2003 x64 r2

2 1

[MonetDB-users] how to completely remove the MonetDB5 installation?
by ewilde 14 Apr '08

14 Apr '08

thanks for replying my previous message. as i mentioned in the previous message, the first installation worked fine (more or less), so in order to finish evaluating MonetDB5 regarding my certain needs, i just want to completely remove it and re-install it. it looks like that the installation program doesn't completely remove the MonetDB5 installation, so, what's the secrete? how do i (manually) completely remove the installation, so i be able to successfully re-install it as it happened the … [View More]

3 2

[MonetDB-users] Error building PF/Tijah index
by Desislava I. Petkova 14 Apr '08

14 Apr '08

Hello I'm trying to build a full-text PF/Tijah index. After starting the Mserver, I add 10 XML files into a new collection. I've divided the collection into files so that the files are not too large. This finishes without errors and the collection exists since pf:collections( ) <> returns <collection updatable="false" size="100 MiB" numDocs="1">dblp.xml1</collection>, <collection updatable="false" size="61 MiB" numDocs="1">dblp.xml10</collection>, <… [View More]

2 1

[MonetDB-users] mserver crashes on windows server 2003 x64
by ewilde 14 Apr '08

14 Apr '08

hi, i do the following steps: 1. run the install program: MonetDB5-SQL-Installer-x86_64-20080214.msi 2. from the start menu, run the shortcut: MonetDB SQL Server 3. from the start menu, run the shortcut: MonetDB SQL Client and... the MonetDB SQL Server window disapears.... a few days ago i installed it (first time in my life) and it worked. i started doing some testing for a couple of days, and suddenly the server stopped working. finally, i gave up: i removed it (using the install program) … [View More]

2 1

[MonetDB-users] New to MonetDB
by Shankar Yoganathan 13 Apr '08

13 Apr '08

Hello I am new to monetDB. I have a few questions about using MonetDB in embedded environment. I read in the embedded server page that only client is allowed to connect to the embedded server. 1. Does this mean I can not have multiple processes accessing the same database? 2. Can multiple threads with in the same process access the same database? 3. in the in-memory embedded environment, is there a way to save the data before the system shutdown? So that when the system starts, I can … [View More]

3 2