Every time we get an error message in the log. See below.
We think of there are a oracle function ctx_dll.sync_index in the general code (search/tcl/search-procs.tcl). That function not exists in Postgres. How could replace that
function for a postgres right function?
-------------------------------------------
[19/jul/2007:19:25:08][20312.1088297328][-sched:26-] Error: dbinit: error(pizarradb.uv.es:5437:openacsdb_5_3_07_08,ERROR: syntax error at or near
"ctx_ddl" at character 1
QUERY: ctx_ddl.sync_index ('swi_index')
CONTEXT: SQL statement in PL/PgSQL function "__exec_3885_optimize_intermedia_index" near line 2
): 'create function __exec_3885_optimize_intermedia_index () returns varchar as '
begin
ctx_ddl.sync_index (''swi_index'');
end;
but I am seeing the code and I think of that that code is running, both Postgres and Oracle:
ad_proc -private search::indexer {} {
Search indexer loops over the existing entries in the search_observer_queue
table and calls the appropriate driver functions to index, update, or
delete the entry.