May 2011 - users-list

[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 installation to start with the system. Thanks, Brien

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: * Compilation specifics: Host: i386-unknown-openbsd4.9 Compiler: gcc CFLAGS: -g -O2 $(X_CFLAGS) -Wno-declaration-after-statement X_CFLAGS: LDFLAGS: * Enabled/disabled components: common is enabled monetdb5 is enabled sql is enabled geom is disabled (geos library required for geom module) fits is enabled rdf is disabled (by default) unixodbc is enabled java is enabled jdbc is enabled control is enabled testing is enabled * Important options: OID size: 32 bits When I run "make" is crashes giving me these erros (they are also attached): gcc: ../../../common/options/monet_options.c: No such file or directory gcc: no input files *** Error code 1 ... *** Error code 1 ... Mike

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