May 2011 - users-list

[MonetDB-users] Alter Table
by Henning Grosch 11 May '11

11 May '11

Is it somehow possible to to add a column with alter table behind an specific column? Example: ALTER TABLE xxx ADD COLUMN newCol int AFTER oldCol; Henning

2 1

[MonetDB-users] wrong results for group by queries
by Daniel Boesswetter 05 May '11

05 May '11

Hi, we are using MonetDB (Oct-2010) for analyzing a 250G data warehouse and have found at least one "thing" which might be a serious bug. The simplest scenario that I have found to describe it, is as follows: SELECT comp.id as compid, comp.name, affnets.name as affid FROM toc INNER JOIN app ON toc.application_id=app.id INNER JOIN comp ON app.company_id = comp.id INNER JOIN affnets ON toc.affiliate_network_id=affnets.id GROUP BY compid, comp.name, affid This query is supposed to return all … [View More]

4 10

[MonetDB-users] Records deleted still appear in: select count(*) from table
by Osmin Castillo 05 May '11

05 May '11

Hi guys: After delete some records from a table using a "delete from table where field=value" criteria, why the "select cont(0) from table" still shows the same records count? Maybe the records are only "marked" and not really removed from the table? Thanks in advance Osmin

3 8

[MonetDB-users] System-wide installation as of April11 release
by brien colwell 05 May '11

05 May '11

Hi all, I recently upgraded one machine to the April11 release of MonetDB. In the April11 release, what is the recommended way to start monetdb with the system, as it used to be done with the rc*.d scripts? For me, maybe a bug, the /etc/init.d/monetdb-sql script is broken (Starting MonetDB SQL server: unable to open 'merovingian.log': Permission denied ... and other missing file, permission errors). Currently I can start the server using 'sudo monetdbd', but of course I want the system-wide … [View More]

3 2

[MonetDB-users] Inserted table in triggers
by Vassilis Papakonstantinou 04 May '11

04 May '11

Hello, I want to use a trigger to get the last inserted row of a table so i can insert some fields of this row to another table. Is there something like the INSERTED table in sql server so i can get the row? Thanks Vassilis

1 0

[MonetDB-users] MonetDB-11.3.1 on OpenBSD 4.9 i386 fails during make
by Michael Sioutis 04 May '11

04 May '11

Hello, I didn't now whether I should send a bug report about this, because I am not sure whether the problem occurs because of a bug in the MonetDB source code or my current unfamiliarity with OpenBSD. I downloaded the April2011 tarball from here: http://dev.monetdb.org/downloads/sources/Apr2011/ I installed all required libraries/programs and configuration went fine (except some warning parts which I will attach). The configurations is as follows: MonetDB is configured as follows: * … [View More]

2 9

[MonetDB-users] Fwd: wkb representation of a geometry
by Georgios Garmpis 04 May '11

04 May '11

Hi, I need to get the Well Known Binary representation of a geometry but I didn't find any function in documentation to do this. Any ideas? -- George Garbis

4 11

[MonetDB-users] How does MonetDB work
by anjenny 04 May '11

04 May '11

Hey, my name is anjenny and im doin a little research on MonetDB for a project. My Question is How does MonetDB actually work? Greetings anjenny -- View this message in context: http://old.nabble.com/How-does-MonetDB-work-tp31440282p31440282.html Sent from the monetdb-users mailing list archive at Nabble.com.

5 7