Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-create.sql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-create.sql 15 Feb 2010 20:09:21 -0000 1.1 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-create.sql 15 Jun 2011 16:52:44 -0000 1.2 @@ -22,7 +22,7 @@ create or replace function bt_bug_search__dtrg () returns trigger as ' begin - perform search_observer__enqueue(new.bug_id,''DELETE''); + perform search_observer__enqueue(old.bug_id,''DELETE''); return old; end;' language 'plpgsql'; Index: openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.6d1-1.6d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.6d1-1.6d2.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.6d1-1.6d2.sql 15 Jun 2011 16:52:44 -0000 1.1 @@ -0,0 +1,6 @@ +create or replace function bt_bug_search__dtrg () +returns trigger as ' +begin + perform search_observer__enqueue(old.bug_id,''DELETE''); + return old; +end;' language 'plpgsql';