Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql,v
diff -u -r1.7 -r1.7.2.1
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql	9 Jul 2002 15:43:55 -0000	1.7
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql	4 Oct 2002 08:08:20 -0000	1.7.2.1
@@ -4,7 +4,7 @@
 -- Copyright (C) 1999-2000 ArsDigita Corporation
 -- Author: Hiro Iwashima (iwashima@mit.edu)
 
--- $ID$
+-- $Id$
 
 -- This is free software distributed under the terms of the GNU Public
 -- License.  Full text of the license is available from the GNU Project:
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.4.4.2 -r1.4.4.3
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql	3 Oct 2002 19:30:19 -0000	1.4.4.2
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql	4 Oct 2002 08:08:20 -0000	1.4.4.3
@@ -1,3 +1,4 @@
+-- @cvs-id $Id$ 
 ------------------------------------------------------------
 -- declare CR as a content provider for search/indexing interface
 ------------------------------------------------------------
@@ -87,6 +88,8 @@
 
 create function content_search__dtrg ()
 returns opaque as '
+declare
+     v_live_revision integer;
 begin
     select into v_live_revision live_revision from
 	cr_items where item_id=old.item_id;
Index: openacs-4/packages/acs-content-repository/sql/postgresql/types-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/types-drop.sql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-content-repository/sql/postgresql/types-drop.sql	27 Mar 2001 02:02:31 -0000	1.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/types-drop.sql	4 Oct 2002 08:08:20 -0000	1.1.4.1
@@ -2,7 +2,7 @@
 
 -- Copyright (C) 20000 ArsDigita Corporation
 
--- $ID$
+-- $Id$
 
 -- This is free software distributed under the terms of the GNU Public
 -- License.  Full text of the license is available from the GNU Project: