Re: [Virtuoso-users] Insert trigger on RDF_QUAD fires twice

2013-10-29 Thread Hugh Williams
Hi Markus, We are looking into this and will report back with finds and/or fix ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/open

Re: [Virtuoso-users] Insert trigger on RDF_QUAD fires twice

2013-10-24 Thread Jürgen Jakobitsch SWC
hi markus, sorry, i cannot reproduce the double-insert behaviour with Version: 06.01.3127 . i used a copy of your code with the only difference being that i do not use an INSERT into another table, but a dbg_obj_print(N.S); dbg_obj_print(N.P); dbg_obj_print(N.O); this way you can also make sure

Re: [Virtuoso-users] Insert trigger on RDF_QUAD fires twice

2013-10-23 Thread Markus Freudenberg
Hello, any trigger syntax will do, e.g.: create trigger BLUB AFTER INSERT on DB.DBA.RDF_QUAD REFERENCING NEW AS N { if(N.G IS NOT NULL AND N.S IS NOT NULL AND N.P IS NOT NULL AND N.O IS NOT NULL) { INSERT INTO A_TRIPLETEST VALUES(N.G, N.S, N.P, N.O, now()); } } after executing this: SPARQL PREF

Re: [Virtuoso-users] Insert trigger on RDF_QUAD fires twice

2013-10-23 Thread Jürgen Jakobitsch SWC
hi sebastian, is the source code of your trigger available to take a look at it? in any case, a "set triggers off;" might be useful [1]. wkr jürgen [1] http://docs.openlinksw.com/virtuoso/TRIGGERS.html On Wed, 2013-10-23 at 11:55 +0200, Sebastian Tramp wrote: > On Wed, Oct 23, 2013 at 11:49:23

[Virtuoso-users] Insert trigger on RDF_QUAD fires twice

2013-10-23 Thread Sebastian Tramp
On Wed, Oct 23, 2013 at 11:49:23AM +0200, Markus Freudenberg wrote: Dear list and Hugh esp., one of our students here has an issue with insert triggers, can you please look into it: > I noticed, that every triple inserted in the virtuoso quad-table will cause > an insert trigger to fire twice (v