Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -r1.109.2.10 -r1.109.2.11
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	2 Feb 2016 13:14:09 -0000	1.109.2.10
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	2 Feb 2016 13:27:52 -0000	1.109.2.11
@@ -7,7 +7,7 @@
   <initial-install-p>t</initial-install-p>
   <singleton-p>t</singleton-p>
 
-  <version name="5.9.1d2" url="http://openacs.org/repository/download/apm/acs-content-repository-5.9.1d2.apm">
+  <version name="5.9.1d3" url="http://openacs.org/repository/download/apm/acs-content-repository-5.9.1d3.apm">
     <owner url="http://openacs.org">OpenACS</owner>
     <summary>The canonical repository for OpenACS content.</summary>
     <release-date>2015-10-04</release-date>
@@ -19,7 +19,7 @@
     <license>GPL</license>
     <maturity>3</maturity>
 
-    <provides url="acs-content-repository" version="5.9.1d2"/>
+    <provides url="acs-content-repository" version="5.9.1d3"/>
     <requires url="acs-kernel" version="5.9.0"/>
     <requires url="acs-tcl" version="5.9.1d2"/>
     <requires url="acs-service-contract" version="5.9.0"/>
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql,v
diff -u -r1.10 -r1.10.2.1
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql	27 Apr 2015 15:28:16 -0000	1.10
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql	2 Feb 2016 13:27:52 -0000	1.10.2.1
@@ -131,11 +131,13 @@
 
 CREATE OR REPLACE FUNCTION content_item_search__utrg () RETURNS trigger AS $$
 BEGIN
-    if new.live_revision is not null and coalesce(old.live_revision,0) <> new.live_revision and (select publish_date from cr_revisions where revision_id=new.live_revision) <= current_timestamp then
+    if new.live_revision is not null and coalesce(old.live_revision,0) <> new.live_revision
+    and (select publish_date from cr_revisions where revision_id=new.live_revision) <= current_timestamp then
         perform search_observer__enqueue(new.live_revision,'INSERT');        
     end if;
 
-    if old.live_revision is not null and old.live_revision <> coalesce(new.live_revision,0) then
+    if old.live_revision is not null and old.live_revision <> coalesce(new.live_revision,0)
+    and (select publish_date from cr_revisions where revision_id=old.live_revision) <= current_timestamp then
         perform search_observer__enqueue(old.live_revision,'DELETE');
     end if;
     if old.live_revision is not null and new.publish_status = 'expired' then
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.1d2-5.9.1d3.sql'.
Fisheye: No comparison available.  Pass `N' to diff?