Nafees Ur Rehman wrote:
Hi,
I tried set history=true; statement to enable history, but it throws an exception that two functions are missing.I want to load these two functions but I don't have them in any of the directory of monetdb. Please note that I am running monetdb SQL on windows xp. The functions are available in the sql/src/sql/history.sql script in the source tree.
You have to define them once for a database. create procedure keepQuery( i wrd, query string, parse bigint, optimize bigint) begin insert into queryHistory values(i, now(), user, query, parse, optimize); end; -- the signature is used in the kernel, don't change it create procedure keepCall( id wrd, -- references query plan ctime timestamp, -- time the first statement was executed arguments string, xtime bigint, -- time from the first statement until result export rtime bigint, -- time to ship the result to the client foot bigint, -- footprint for all bats in the plan memory bigint, -- storage size of intermediates created tuples wrd, -- number of tuples in the result set inblock bigint, -- number of physical blocks read oublock bigint -- number of physical blocks written ) begin insert into callHistory values( id, ctime, arguments, xtime, rtime, foot, memory, tuples, inblock, oublock ); end; set history=true;
I would highly appreciate your kind help.
Regards Nafees Ur Rehman
------------------------------------------------------------------------
------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev
------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users