Index: openacs-4/packages/bug-tracker/bug-tracker.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/bug-tracker.info,v diff -u -N -r1.27 -r1.28 --- openacs-4/packages/bug-tracker/bug-tracker.info 15 Feb 2010 20:09:21 -0000 1.27 +++ openacs-4/packages/bug-tracker/bug-tracker.info 15 Feb 2010 20:21:33 -0000 1.28 @@ -8,7 +8,7 @@ f f - + Lars Pind Tracks bugs and features, versions and maintainers, in software projects. 2008-05-13 @@ -17,7 +17,7 @@ Contains the best of SDM, Bugzilla, FogBUGZ, and bughost.com. 0 - + Index: openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.4d6-1.4d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/Attic/upgrade-1.4d6-1.4d7.sql,v diff -u -N --- openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.4d6-1.4d7.sql 15 Feb 2010 20:09:21 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,37 +0,0 @@ - --- Bug tracker search triggers --- --- @author Don Baccus (dhogaza@pacifier.com) --- @cvs-id $Id: upgrade-1.4d6-1.4d7.sql,v 1.1 2010/02/15 20:09:21 donb Exp $ - --- Triggers for the bug item table. - -create or replace function bt_bug_search__itrg () -returns trigger as ' -begin - perform search_observer__enqueue(new.bug_id,''INSERT''); - return new; -end;' language 'plpgsql'; - -create or replace function bt_bug_search__utrg () -returns trigger as ' -begin - perform search_observer__enqueue(new.bug_id,''UPDATE''); - return old; -end;' language 'plpgsql'; - -create or replace function bt_bug_search__dtrg () -returns trigger as ' -begin - perform search_observer__enqueue(new.bug_id,''DELETE''); - return old; -end;' language 'plpgsql'; - -create trigger bt_bug_search__itrg after insert on bt_bugs -for each row execute procedure bt_bug_search__itrg (); - -create trigger bt_bug_search__utrg after update on bt_bugs -for each row execute procedure bt_bug_search__utrg (); - -create trigger bt_bug_search__dtrg after delete on bt_bugs -for each row execute procedure bt_bug_search__dtrg (); Index: openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.4d6-1.6d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.4d6-1.6d1.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.4d6-1.6d1.sql 15 Feb 2010 20:21:33 -0000 1.1 @@ -0,0 +1,37 @@ + +-- Bug tracker search triggers +-- +-- @author Don Baccus (dhogaza@pacifier.com) +-- @cvs-id $Id: upgrade-1.4d6-1.6d1.sql,v 1.1 2010/02/15 20:21:33 donb Exp $ + +-- Triggers for the bug item table. + +create or replace function bt_bug_search__itrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''INSERT''); + return new; +end;' language 'plpgsql'; + +create or replace function bt_bug_search__utrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''UPDATE''); + return old; +end;' language 'plpgsql'; + +create or replace function bt_bug_search__dtrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''DELETE''); + return old; +end;' language 'plpgsql'; + +create trigger bt_bug_search__itrg after insert on bt_bugs +for each row execute procedure bt_bug_search__itrg (); + +create trigger bt_bug_search__utrg after update on bt_bugs +for each row execute procedure bt_bug_search__utrg (); + +create trigger bt_bug_search__dtrg after delete on bt_bugs +for each row execute procedure bt_bug_search__dtrg ();